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
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search