Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Initialization Parameters, 194 of 222
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:
|
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|