What is a shared pool?

Submitted by: Administrator
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
Submitted by: Administrator

Read Online Memory Management Job Interview Questions And Answers