Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 658
  • Last Modified:

Oracle 11g

Hi,

When I am running the below command,

exec DBMS_STATS.GATHER_TABLE_STATS (ownname=>'SCOTT', tabname=>'REDEF_TEST_INT', estimate_percent=>100, cascade=>true, degree=>8);

I am getting the below error
ORA-12801: error signaled in parallel query server P001
ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
ORA-06512: at "SYS.DBMS_STATS", line 20337
ORA-06512: at "SYS.DBMS_STATS", line 20360
ORA-06512: at line 1

I reduced the estimate_percent to 10 and degree to 2 and ran again. But still I got the same error.
The table is of size 21GB. about(100,000,000 records)

Can you please let me know how can I take the table stats for this table without getting this error?

Thanks.
0
GouthamAnand
Asked:
GouthamAnand
1 Solution
 
sventhanCommented:
Try to run with no-parallel or, increase the memory.

What is your SGA size?

exec DBMS_STATS.GATHER_TABLE_STATS (ownname=>'SCOTT', tabname=>'REDEF_TEST_INT', estimate_percent=>100, cascade=>true, degree=>1);
0
 
GouthamAnandAuthor Commented:
Thank you. I could run successfully with no parallel.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now