What is Shared Pool ?

Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.

Interview Candidate
Sep 6th, 2004
2
8654

Showing Answers 1 - 2 of 2 Answers

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.