What is Data-Dictionary Cache?

<<Previous  Next>>

Oracle - What is Data-Dictionary Cache? - June 27, 2009 at 11:00 AM

What is Data-Dictionary Cache?  

Data-Dictionary Cache keeps information about the logical and physical structure of the database.

The data dictionary contains information such as the following:

User information, such as user privileges
Integrity constraints defined for tables
Names and data types of all columns in database tables
Information on space allocated and used for schema objects 

Also read

What is the use of Data Dictionary in oracle?

Data Dictionary is used to store information about various physical and logical Oracle structures, e.g.Tables, Tablespaces, datafiles, etc.........

What are constraints?

It is the rules that prevent the invalid entry into the table. They are stored in the data dictionary. They can be defined either at column level or table level...........

What is a static data dictionary in Oracle?

The information in data dictionary can be accessed through data dictionary views as they are not directly accessible............

What is a database buffer cache?

Database buffer cache is a component of SGA. It has the responsibility to cache most recent accessed data. It keeps the transaction in the buffer cache till it is written on the disk............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience