Fernando

• Oct 13th, 2005

 

The shared pool portion of the SGA contains three major areas: library cache, dictionary cache, buffers for parallel execution messages, and control structures

puneet soni

• Apr 1st, 2006

 

shared pool consist of 2 memory layers-library cache and datadictionary cache...library cache -contains parsed sql statements,cursor information,execution plansdata dictionary cache -user account information,priveleges information,datafile,segment and extent information stored into the data dictionary cache.

Sivaramasamy

• Apr 26th, 2006

 

 The shared pool is an area in the SGA Which contains the shared SQL areas and  the data dictionary cache

Chinny

• Sep 28th, 2006

 

Sharedpool contains 3 memory layers.

1.Library cache:

2.Data dictionary cache

3.UGA

Tony

• Oct 25th, 2006

 

Thanks for the information!