|
Parameter type
|
Big integer
|
|
Syntax
|
SHARED_POOL_SIZE = integer [K | M | G]
|
|
Default value
|
32-bit platforms: 8 MB, rounded up to the nearest granule size
64-bit platforms: 64 MB, rounded up to the nearest granule size
|
|
Parameter class
|
Dynamic: 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.
