About this document

Oracle Metadata: Dictionary vs. Performance Views by FrancesHsieh is a document available to read on EtoBox.

Oracle metadata includes data dictionary views and dynamic performance views. The SYS user owns these views, which are stored in the SYSTEM tablespace. Data dictionary views provide information about database objects, while dynamic performance views contain dynamic statistical data about performance. Both types of views store information used for self-tuning and administration, but dynamic views can show data when the database is not fully open.

Author

FrancesHsieh

Language

EN