Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterviewWhat do you understand about the memory layers that are in the Oracle shared pool?
bg slide el 1

What do you understand about the memory layers that are in the Oracle shared pool?

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

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...