What is Shared Pool in Oracle System Architecture?
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle System Architecture Job Interview Questions And Answers
