| View Name | Description |
|---|
| AUDIT_ACTIONS | Descriptions for audit trail action type codes |
| CHAINED_ROWS | CHAINED ROWS ANALYZE command output |
| COLUMN_PRIVILEGES | Accessible column grants |
| DBMS_ALERT_INFO | User allocated locks |
| DEPTREE | Object dependancy tree and shared cursors |
| DICTIONARY | Data dictionary tables and views |
| DICT_COLUMNS | Data dictionary table and view columns |
| EXCEPTIONS | Integrity contraint violations |
| FILE_LOCK | PCM locks to datafiles mappings based on GC_FILES_TO_LOCKS in parallel server |
| FILE_PING | Datafile number of blocks pinged which can show datafile access and allow correct GC_FILES_TO_LOCKS setting in parallel server |
| FILEXT$ | DBA_DATA_FILES equivalent |
| GLOBAL_NAME | Current database global name |
| IDEPTREE | Indented dependancy tree |
| INDEX_HISTOGRAM | ANALYZE INDEX ... VALIDATE STRUCTURE command |
| INDEX_STATS | Last ANALYZE INDEX ... VALIDATE STRUCTURE command execution |
| OBJ | USER_OBJECTS sysnonym |
| ORPHAN_KEY_TABLE | DUMP_ORPHAN_KEYS corrupt rows |
| PLAN_TABLE | EXPLAIN PLAN results |
| PLUGGABLE_SET_CHECK | Pluggable set checks |
| PRODUCT_COMPONENT_VERSION | Version and status |
| PROXY_USERS | Users assuming identity of other users |
| PSTUBTBL | PSTUB generations (Oracle Forms 3) |
| PUBLIC_DEPENDENCY | Object dependancies both to and from those objects |
| QUEUE_PRIVILEGES | Session grant advanced queueing object privelages |
| RC | Optional recovery catalog |
| REPAIR_TABLE | CHECK_OBJECT procedure corruptions and used when executing FIX_CORRUPT_BLOCKS and REFORMAT_CORRUPT_BLOCKS |
| RESOURCE_COST | Resource costs |
| RESOURCE_MAP | Resource descriptions |
| ROLE_ROLE_PRIVS | Roles granted to roles |
| ROLE_SYS_PRIVS | System privelages granted to roles |
| ROLE_TAB_PRIVS | Table privelages granted to roles |
| SESSION_CONTEXT | Current session set attributes |
| SESSION_PRIVS | Current session privelages |
| SESSION_ROLES | Current session roles |
| STMT_AUDIT_OPTION_MAP | Auditing option type codes |
| SYS_OBJECTS | Mappings between OIDs and object types plus segment data block addresses |
| SYSTEM_PRIVILEGE_MAP | System privelage codes |
| TABLE_PRIVILEGE_MAP | Access privelage codes |
| TRUSTED_SERVERS | Trusted or untrusted server details |
| TS_PITR_CHECK | Point in time recovery for tablespaces |
| TS_PITR_OBJECTS_TO_BE_DROPPED | Point in time recovery for tablespaces |
| UNI_PLUGGABLE_SET_CHECK | Puggable checks |
| DBMS_LOCK_ALLOCATED | Replication |
| DEFCALL | Replication |
| DEFCALLDEST | Replication |
| DEFDEFAULTDEST | Replication |
| DEFERRCOUNT | Replication |
| DEFERROR | Replication |
| DEFLOB | Replication |
| DEFPROPAGATOR | Replication |
| DEFSCHEDULE | Replication |
| DEFTRAN | Replication |
| DEFTRANDEST | Replication |
| CODE_PIECES | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| CODE_SIZE | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| ERROR_SIZE | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| PARSED_PIECES | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| PARSED_SIZE | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| SOURCE_SIZE | Accesses the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views |
| HS_ALL_CAPS | Non-Oracle FDS data stores - features |
| HS_ALL_DD | Non-Oracle FDS data stores - data dictionary |
| HS_ALL_INITS | Non-Oracle FDS data stores - initialisation parameters |
| HS_BASE_CAPS | Non-Oracle FDS data stores - basic features |
| HS_BASE_DD | Non-Oracle FDS data stores - basic data dictionary |
| HS_CLASS_CAPS | Non-Oracle FDS data stores - class features |
| HS_CLASS_DD | Non-Oracle FDS data stores - class data dictionary |
| HS_CLASS_INIT | Non-Oracle FDS data stores - class initialisation parameters |
| HS_EXTERNAL_OBJECT_PRIVILEGES | Non-Oracle FDS data stores - object privelages |
| HS_EXTERNAL_OBJECTS | Non-Oracle FDS data stores - distributed external objects |
| HS_EXTERNAL_USER_PRIVILEGES | Non-Oracle FDS data stores - non-object privelages |
| HS_FDS_CLASS | Non-Oracle FDS data stores - non-Oracle classes |
| HS_FDS_INST | Non-Oracle FDS data stores - non-Oracle instances |
| HS_INST_CAPS | Non-Oracle FDS data stores - instance features |
| HS_INST_DD | Non-Oracle FDS data stores - instance data dictionary |
| HS_INST_INIT | Non-Oracle FDS data stores - instance initialisation parameters |
| NLS_DATABASE_PARAMETERS | Database NLS (national language set) parameters |
| NLS_INSTANCE_PARAMETERS | Instance NLS (national language set) parameters |
| NLS_SESSION_PARAMETERS | Session NLS (national language set) parameters |
| CAT | USER_CATALOG synonym |
| CLU | USER_CLUSTERS synonym |
| COLS | USER_TAB_COLUMNS synonym |
| DICT | DICTIONARY synonym |
| IND | USER_INDEXES synonym |
| PUBLICSYN | Public synonyms |
| SEQ | USER_SEQUENCES synonym |
| SYN | USER_SYNONYMS synonym |
| TABS | USER_TABLES synonym |
| CATALOG | Oracle5 compatibility |
| COL | Oracle5 compatibility |
| SYSCATALOG | Oracle5 compatibility |
| SYSFILES | Oracle5 compatibility |
| SYNONYMS | Oracle5 compatibility |
| SYSSEGOBJ | Oracle5 compatibility |
| TAB | Oracle5 compatibility |
| TABQUOTAS | Oracle5 compatibility |
| TABLE_PRIVILEGES | Oracle6 compatibility |