First page Back Continue Last page Graphics
Shared Pool
Shared memory area
Contains many "sub" areas
- Dictionary cache
- Recently access parts of data dictionary
- Library cache
- Recently parsed SQL statements
- Many other areas
- E.g. system initialization parameters
Size primarily by SHARED_POOL_SIZE parameter
Notes:
The shared pool is one of the large (typically) and important areas of the SGA. (I say large because it is typically a large percentage of the total memory used by the SGA. I say important because an improperly tuned shared pool will degrade overall system performance.)
It is here that Oracle caches the data dictionary (dictionary cache) and recently executed SQL statements (library cache).
The shared pool is one of the areas that the DBA will tune to achieve best overall performance from the database. The size of the shared pool is primarily controlled with the SHARED_POOL_SIZE parameter. (Note that Oracle puts many other things into the shared pool, over which we have no control, so the size of the pool will not be equal to the SHARED_POOL_SIZE parameter.)
Refer to SkillBuilders course Oracle9i New Features for DBAs for tips on using the shared pool advisory for tuning the size of the shared pool.