Tag Archives: health

List of CDB views available in Oracle container databases

CDB_* views available in Oracle:

  • CDB_TABLESPACES: Provides information about tablespaces in the CDB.
  • CDB_USERS: Lists all users in the CDB.
  • CDB_OBJECTS: Details objects in the CDB.
  • CDB_ROLE_PRIVS: Shows role privileges in the CDB.
  • CDB_TABLES: Information about tables in the CDB.
  • CDB_INDEXES: Details about indexes in the CDB.
  • CDB_CONSTRAINTS: Information on constraints in the CDB.
  • CDB_PARTITIONS: Details about partitions in the CDB.
  • CDB_FILESTATS: Provides file statistics for the CDB.
  • CDB_DATAFILES: Lists datafiles in the CDB.
  • CDB_TAB_STATISTICS: Provides table statistics in the CDB.
  • CDB_INC_BACKUP: Information about incremental backups in the CDB.
  • CDB_PDBS: List the information about Status of PDBs.
  • CDB_PROPERTIES: Displays the permanent properties of each container in a CDB.
  • CDB_PDB_HISTORY: Displays the history of each PDB.
  • CDB_Container_data: Displays information about user level and object level data attributes specified in CDB.
  • CDB_PDB_SAVED_STATE: Displays the PDBs and instances in the workload repository.
  • CDB_SERVICES: Displays information about database services.
  • CDB_VIEWS: Information about views in the CDB.