Memory Architecture   «Prev 

Oracle Shared pool

The library cache contains the shared SQL area, PL/SQL code, and some control structures.

The shared SQL area contains parse trees, and execution plans for SQL statements.

The library cache holds PL/SQL packages, procedures, and functions. Multiple users of a PL/SQL program unit all share a single copy of the code

Control structures in the library cache include locks and library cache handles

To improve performance, the data dictionary cache holds the most recently accessed data dictionary records

Control structures in the main area of the shared pool include character set conversion memory and network security attributes