Sapna Malik
What is Data Dictionary Cache in Oracle?
By Sapna Malik in Databases & DBA on Apr 13 2011
  • Sapna Malik
    Apr, 2011 19

    The data dictionary is a collection of database tables and views containing reference information about the database, its structures, and its users. Oracle accesses the data dictionary frequently during SQL statement parsing. This access is essential to the continuing operation of Oracle.

    The data dictionary is accessed so often by Oracle that two special locations in memory are designated to hold dictionary data. One area is called the data dictionary cache, also known as the row cache because it holds data as rows instead of buffers (which hold entire blocks of data). The other area in memory to hold dictionary data is the library cache. All Oracle user processes share these two caches for access to data dictionary information.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS