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?