First page Back Continue Last page Graphics
Data Dictionary Cache
Part of the shared pool
Caches portions of the data dictionary, e.g.
- Information on segments
- Space availability information
- Object privilege information
Used when
- DDL is issued
- More extents are required
- Any statement is parsed
Notes:
The data dictionary cache caches the Oracle data dictionary. This increases the efficiency of accessing the data dictionary. This is important because of the frequency of accessing the data dictionary. Just think, every time an SQL DML statement is parsed the dictionary is accessed to validate table and column references, privileges and to check for indexes.