String 

SHARED_POOL_SIZE = integer [K | M] 

Static 

If 64 bit, 64MB, else 16MB 

300 Kbytes to operating system dependent 

SHARED_POOL_SIZE specifies in bytes the size of the shared pool. The shared pool contains shared cursors, stored procedures, control structures, and other structures. If you set PARALLEL_AUTOMATIC_TUNING to FALSE, Oracle also allocates parallel execution message buffers from the shared pool. Larger values improve performance in multiuser systems. Smaller values use less memory.

You can monitor utilization of the shared pool by querying the view V$SGASTAT.  

See Also:

• Oracle8i Designing and Tuning for Performance for more information on setting this parameter.

• Oracle8i Migration for information on parallel execution message buffers.

• "PARALLEL_AUTOMATIC_TUNING" and "V$SGASTAT".