There are two memory layers in the Oracle shared pool:-
- Library Cache – The information about the SQL statements that were parsed, data about cursors, and any plan data that might be present is present in the Library Cache.
- Data Dictionary Cache – The Data Dictionary Cache layer contains information about the accounts of the users, their privileges, and information about segments