Oracle Metadata Views


View NameDescription
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