Oracle System Architecture Question:

Download Questions PDF

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.