The Shared Pool environment contains both fixed and variable structures. The Fixed structures remain relatively the same size, whereas the variable structures grow and shrink based on user and program requirements.

Used To Store

Most Recently Executed SQL Statements

Most Recently used Data definitions

It Consists of two Key performance - related memory structures

Library Cache & Data Dictionary Cache

Shared Pool is sized by SHARED_POOL_SIZE