parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

 

Hi,

Actually Shared pool is composed of two parts one is Library Cache and another Data Dictionary cache

The Library cache contains the shared sql areas, private sql areas, PL/SQL procedures and packages, and control structures such as locks and Library cache handles, The shared sql area contains the parse tree and execution plan where as the private sql area contains values for bind variables and runtime buffers.

the data dictionary cache holds most recently used database dictionary informations.

Regards,

partho konar

Mohammed Abdul Afroze

• Oct 16th, 2007

 

Shared Pool compromises of Library Cache and Dictionary Cache.Library Cache stores and shares sql stmts where as plsql stmts in memory.

Dictionary Cache: Oracle continously request and update information in the data dictionary of the db.To maximize the performance of the system internal operation.Data Dictionary cache holds dictionary information.