The shared pool

The shared pool is the portion of SGA contains the following main parts:

1. The Library Cache includes sharable parts of SQL statments, PL/SQL procedures and packages
2. The Data Dictionarry is a collection of database tables containing reference information about the database.
3. The Result Cache is used for storing results of SQL statments and PL/SQL procedures.
4. Lock Structures