Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_stats on BIG Table giving error out of process memory when trying to allocate 1049100 bytes

dbms_stats on BIG Table giving error out of process memory when trying to allocate 1049100 bytes

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 19 Aug 2005 11:40:51 +0530
Message-ID: <B5587533FCBD4344ADB8290B3EDDA12208489CBF@kecmsg14.ad.infosys.com>

SQL> alter session set sort_area_size=500000000

SQL> exec
dbms_stats.gather_table_stats('TBAADM','HIST_TRAN_DTL_TABLE',degree=>4,e stimate_percent=>30);

 ERROR at line 1:

ORA-12801: error signaled in parallel query server P000

ORA-04030: out of process memory when trying to allocate 1049100 bytes

(callheap,kllcqas:kllsltba)

ORA-06512: at "SYS.DBMS_STATS", line 9375

ORA-06512: at "SYS.DBMS_STATS", line 9389

ORA-06512: at line 1

Existing Pointers :-

Sometimes decreasing the size of your sort_area_size will remedy this problem.

Another thought is that if you are using parallel query on this view, perhaps the amount of memory required for the number of slaves handling the query is growing too big.

Qs ANY OTHER POINTERS PLEASE?

Server info:-


Server 2 GB memory

2 CPUs

Solaris 9

Oracle 9i

THANKS INDEED

Received on Fri Aug 19 2005 - 01:16:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US