|
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
-------------------------- ----------
PX msg pool 40.1
free memory 151.9
large_pool 192
If you run out of free memory in the large pool then increase it.
alter system set large_pool_size = 289539635 scope=both
|
