• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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