Oracle Memory Management Question:
Download Job Interview Questions and Answers PDF
What is a shared pool?
Answer:
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
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
Download Memory Management Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the OPTIMAL parameter? | What is mean by Program Global Area (PGA)? |