<<Previous Next>>
Oracle - What is the use of
Data Dictionary in oracle? - Feb 23, 2010 at 11:00 PM by
Rajmeet Ghai
What is the use of Data Dictionary in oracle?
Data Dictionary in Oracle contains a set of tables that carry
read only database information. It contains information like
definition of tables, views, clusters, synonyms etc, default values
for columns, privilege and role information.
Oracle - What
is the use of Data Dictionary in oracle? - April 10, 2009
at 11:00 AM by
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.
Also read
Data-Dictionary Cache keeps information about the logical and
physical structure of the database..........
The information in data dictionary can be accessed through data
dictionary views as they are not directly accessible............
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.............
|
