Static Data Dictionary Views

Part II Static Data Dictionary Views

This part describes data dictionary tables and views. These tables and views are called static, because they change only when a change is made to the data dictionary (for example, when a new table is created or when a user is granted new privileges).

This part contains the following chapters:

Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS

Note:

Oracle also maintains views that monitor ongoing database activity. These dynamic performance views are described in Dynamic Performance Views.

Note:

A multitenant container database is the only supported architecture in Oracle Database 21c. While the documentation is being revised, legacy terminology may persist. In most cases, "database" and "non-CDB" refer to a CDB or PDB, depending on context. In some contexts, such as upgrades, "non-CDB" refers to a non-CDB from a previous release.