SHARED_POOL

SHARED_POOL_SIZE

Property	Description
Parameter type	Big integer
Syntax	`SHARED_POOL_SIZE =` `integer` `[K \| M \| G]`
Default value	If `SGA_TARGET` is set: If the parameter is not specified, then the default is `0` (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool. If `SGA_TARGET` is not set (32-bit platforms): 32 MB, rounded up to the nearest granule size If `SGA_TARGET` is not set (64-bit platforms): 84 MB, rounded up to the nearest granule size
Modifiable	`ALTER SYSTEM`
Range of values	Minimum: the granule size Maximum: 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, then 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:

Oracle Database Performance Tuning Guide for more information on setting this parameter
Oracle Database Upgrade Guide for information on parallel execution message buffers
"PARALLEL_AUTOMATIC_TUNING" and "V$SGASTAT"