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 and later releases. 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.