Large pool size and contents
                                                 Last update (2011-05-07 15:56:49)
                                                                                                                   Date added (2010-01-12 10:19:38)

Summary
Typically a size of 64MB is sufficient for most large pools, but if this is not enough and get errors like this:
ORA-04031: unable to allocate 65704 bytes of shared 
memory ("large pool","unknown object","large pool","PX msg pool")
or
ORA-12853: insufficient memory for PX buffers: 
current 65400K, max needed 1512000K
then you must configure "Large pool" size with a more accuracy.

How much Large pool is used
Use the following query to determine the size of the large pool area currently being used.
SELECT nvl(name, 'large_pool') name, round(SUM(bytes)/1024/1024,2) size_mb 
FROM V$SGASTAT WHERE pool='large pool' 
GROUP BY ROLLUP(name);

NAME                          SIZE_MB
-------------------------- ----------
CTWR dba buffer                  5.89
PX msg pool                    226.56
free memory                   5869.11
krcc extent chunk               13.84
large_pool                    6115.41

If you run out of free memory in the large pool then increase it (for example the statement)
alter system set large_pool_size = 389539635 scope=both;
Reviews
Filters
Search