Ravi Prakash Pichika

• Jun 5th, 2005

 

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 
[B]Ravi Prakash :: mail me @ prakash.dba@gmail.com[/B} 

Mohammed Abdul Afroze

• Mar 25th, 2007

 

Answer:

  Shared Pool Comprises library cache and dictionary cache.Library Cache stores and shares sql statements,where as pl/sql procedure in memory.And the Default size is 8mb.