Search SSWUG.ORG:

DATABASES

Data Dictionary Cache Hit Ratio This is an off-site link.  Please review our Terms of Service for additional information.


(Andrew Reid) Every Oracle database has a data dictionary, which is owned by the SYS user and stored in the SYSTEM tablespace. This consists of read-only tables, which record information about the database e.g. table definitions, details of integrity constraints, usernames and the roles and privileges granted to them etc. You can read about this in detail in Oracle's own documentation.

Read this article..







comments powered by Disqus