What is data dictionary cache?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is data dictionary cache?
Rating:
The data dictionary cache is a portion of the shared pool. It stores information on user rights corresponding to the segments that are involved in a query. It also checks the existence of tables and the validity of data types involved in queries. The data dictionary cache employs the least recently used algorithm for storage management. Unlike the library cache, it does not require an exact textual match of the statements that are issued in order to enhance query performance.
Rating:
Was this information helpful?
Other articles
- What is pending area?
- What are INITRANS and MAXTRANS transaction entry parameters?
- What are shared locks?
- What is DBCA?
- What is an Oracle instance?