SHARED_POOL_SIZE

Parameter type	Big integer
Syntax	SHARED_POOL_SIZE = integer [K | M | G]
Default value	If 64-bit, 64 MB, otherwise 16 MB
Parameter class	Dynamic: ALTER SYSTEM
Range of values	300 KB 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 multi-user systems. Smaller values use less memory.

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

See Also: Oracle9i Database Performance Guide and Reference for more information on setting this parameter Oracle9i Database Migration for information on parallel execution message buffers "PARALLEL_AUTOMATIC_TUNING" and "V$SGASTAT"