Column Name
| Description
|
BASE_OBJECT_TYPE (USER_TRIGGERS)
|
|
BASE_OBJECT_TYPE (DBA_TRIGGERS)
|
|
BASE_OBJECT_TYPE (ALL_TRIGGERS)
|
|
CACHED_OBJECTS (V$SESSION_OBJECT_CACHE)
|
|
CACHED_OBJECTS (GV$SESSION_OBJECT_CACHE)
|
|
DATA_OBJ# (GV$LOGMNR_CONTENTS)
|
|
DATA_OBJ# (V$LOGMNR_CONTENTS)
|
|
DATA_OBJECT_ID (ALL_OBJECTS)
| Object number of the segment which contains the object
|
DATA_OBJECT_ID (ALL_PROBE_OBJECTS)
|
|
DATA_OBJECT_ID (DBA_OBJECTS)
| Object number of the segment which contains the object
|
DATA_OBJECT_ID (OBJ)
| Object number of the segment which contains the object
|
DATA_OBJECT_ID (USER_OBJECTS)
| Object number of the segment which contains the object
|
ESTD_LC_MEMORY_OBJECTS (GV$SHARED_POOL_ADVICE)
|
|
ESTD_LC_MEMORY_OBJECTS (V$SHARED_POOL_ADVICE)
|
|
ESTD_LC_MEMORY_OBJECT_HITS (GV$SHARED_POOL_ADVICE)
|
|
ESTD_LC_MEMORY_OBJECT_HITS (V$SHARED_POOL_ADVICE)
|
|
LC_FREEABLE_MEMORY_OBJECTS (GV$LIBRARY_CACHE_MEMORY)
|
|
LC_FREEABLE_MEMORY_OBJECTS (V$LIBRARY_CACHE_MEMORY)
|
|
LC_INUSE_MEMORY_OBJECTS (V$LIBRARY_CACHE_MEMORY)
|
|
LC_INUSE_MEMORY_OBJECTS (GV$LIBRARY_CACHE_MEMORY)
|
|
OBJ# (GV$SEGMENT_STATISTICS)
|
|
OBJ# (V$SEGSTAT)
|
|
OBJ# (V$SEGMENT_STATISTICS)
|
|
OBJ# (GV$SEGSTAT)
|
|
OBJ# (DBA_IAS_CONSTRAINT_EXP)
|
|
OBJECT (V$ACCESS)
|
|
OBJECT (GV$ACCESS)
|
|
OBJECT# (GV$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT# (GV$SQL_PLAN)
|
|
OBJECT# (V$SQL_PLAN)
|
|
OBJECT# (V$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_COMMENT (ALL_REPOBJECT)
| Description of the replicated object
|
OBJECT_COMMENT (DBA_REPOBJECT)
| Description of the replicated object
|
OBJECT_COMMENT (USER_REPOBJECT)
| User description of the replicated object
|
OBJECT_DATA (GV$DELETED_OBJECT)
|
|
OBJECT_DATA (V$DELETED_OBJECT)
|
|
OBJECT_FLUSHES (V$SESSION_OBJECT_CACHE)
|
|
OBJECT_FLUSHES (GV$SESSION_OBJECT_CACHE)
|
|
OBJECT_ID (USER_OBJECTS)
| Object number of the object
|
OBJECT_ID (V$FIXED_TABLE)
|
|
OBJECT_ID (DBA_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (ALL_OBJECTS)
| Object number of the object
|
OBJECT_ID (V$LOCKED_OBJECT)
|
|
OBJECT_ID (GV$LOCKED_OBJECT)
|
|
OBJECT_ID (USER_ARGUMENTS)
| Object number of the object
|
OBJECT_ID (USER_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (ALL_PROBE_OBJECTS)
|
|
OBJECT_ID (OBJ)
| Object number of the object
|
OBJECT_ID (ALL_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (ALL_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (USER_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (ALL_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (USER_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (ALL_ARGUMENTS)
| Object number of the object
|
OBJECT_ID (DBA_OBJECTS)
| Object number of the object
|
OBJECT_ID (DBA_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (DBA_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (GV$FIXED_TABLE)
|
|
OBJECT_ID_TYPE (ALL_ALL_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (USER_OBJECT_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (USER_REFS)
| If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (DBA_OBJECT_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (ALL_OBJECT_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (ALL_REFS)
| If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (USER_ALL_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM GENERATED
|
OBJECT_ID_TYPE (DBA_REFS)
| If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED
|
OBJECT_ID_TYPE (DBA_ALL_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_NAME (DBA_POLICIES)
| Name of the synonym, table, or view
|
OBJECT_NAME (ALL_ASSOCIATIONS)
| Object name for which the association is being defined
|
OBJECT_NAME (DBA_USTATS)
| Name of the table or index for which the statistics have been collected
|
OBJECT_NAME (DBA_EXP_OBJECTS)
| Name of exported object
|
OBJECT_NAME (ALL_APPLY_CONFLICT_COLUMNS)
| Name of the object
|
OBJECT_NAME (DBA_APPLY_DML_HANDLERS)
| Name of the object
|
OBJECT_NAME (USER_POLICIES)
| Name of the synonym, table, or view
|
OBJECT_NAME (DBA_OBJ_AUDIT_OPTS)
| Name of the object
|
OBJECT_NAME (USER_ASSOCIATIONS)
| Object name for which the association is being defined
|
OBJECT_NAME (ALL_OBJECTS)
| Name of the object
|
OBJECT_NAME (USER_USTATS)
| Name of the table or index for which the statistics have been collected
|
OBJECT_NAME (DBA_POLICY_GROUPS)
| Name of the synonym, table, or view
|
OBJECT_NAME (V$SEGMENT_STATISTICS)
|
|
OBJECT_NAME (DBA_IAS_OBJECTS_BASE)
|
|
OBJECT_NAME (DBA_IAS_OBJECTS_EXP)
|
|
OBJECT_NAME (ALL_POLICIES)
| Name of the synonym, table, or view
|
OBJECT_NAME (ALL_STORED_SETTINGS)
| Name of the object
|
OBJECT_NAME (GV$SEGMENT_STATISTICS)
|
|
OBJECT_NAME (ALL_POLICY_GROUPS)
| Name of the synonym, table, or view
|
OBJECT_NAME (ALL_APPLY_DML_HANDLERS)
| Name of the object
|
OBJECT_NAME (DBA_STORED_SETTINGS)
| Name of the object
|
OBJECT_NAME (V$VPD_POLICY)
|
|
OBJECT_NAME (ALL_ARGUMENTS)
| Procedure or function name
|
OBJECT_NAME (DBA_ANALYZE_OBJECTS)
|
|
OBJECT_NAME (DBA_CACHEABLE_OBJECTS_BASE)
|
|
OBJECT_NAME (DBA_APPLY_KEY_COLUMNS)
| Name of the object
|
OBJECT_NAME (ALL_APPLY_KEY_COLUMNS)
| Name of the object
|
OBJECT_NAME (DBA_APPLY_CONFLICT_COLUMNS)
| Name of the object
|
OBJECT_NAME (USER_PROCEDURES)
| Name of the object : top level function/procedure/package name
|
OBJECT_NAME (DBA_IAS_OBJECTS)
|
|
OBJECT_NAME (DBA_CACHEABLE_OBJECTS)
|
|
OBJECT_NAME (DBA_FGA_AUDIT_TRAIL)
| Name of the table or view
|
OBJECT_NAME (ALL_REPCAT_TEMPLATE_OBJECTS)
| Name of the database object.
|
OBJECT_NAME (ALL_POLICY_CONTEXTS)
| Name of the synonym, table, or view
|
OBJECT_NAME (ALL_AUDIT_POLICIES)
| Name of the table or view
|
OBJECT_NAME (DBA_CACHEABLE_NONTABLE_OBJECTS)
|
|
OBJECT_NAME (ALL_PROCEDURES)
| Name of the object : top level function/procedure/package name
|
OBJECT_NAME (DBA_PROCEDURES)
| Name of the object : top level function/procedure/package name
|
OBJECT_NAME (OBJ)
| Name of the object
|
OBJECT_NAME (USER_AUDIT_POLICIES)
| Name of the table or view
|
OBJECT_NAME (ALL_PROBE_OBJECTS)
|
|
OBJECT_NAME (USER_OBJ_AUDIT_OPTS)
| Name of the object
|
OBJECT_NAME (USER_POLICY_GROUPS)
| Name of the synonym, table, or view
|
OBJECT_NAME (USER_STORED_SETTINGS)
| Name of the object
|
OBJECT_NAME (USER_OBJECTS)
| Name of the object
|
OBJECT_NAME (GV$VPD_POLICY)
|
|
OBJECT_NAME (DBA_REPCAT_TEMPLATE_OBJECTS)
| Name of the database object.
|
OBJECT_NAME (DBA_ASSOCIATIONS)
| Object name for which the association is being defined
|
OBJECT_NAME (ALL_USTATS)
| Name of the table or index for which the statistics have been collected
|
OBJECT_NAME (USER_ARGUMENTS)
| Procedure or function name
|
OBJECT_NAME (DBA_POLICY_CONTEXTS)
| Name of the synonym, table, or view
|
OBJECT_NAME (USER_REPCAT_TEMPLATE_OBJECTS)
| Name of the database object.
|
OBJECT_NAME (USER_POLICY_CONTEXTS)
| Name of the synonym, table, or view
|
OBJECT_NAME (DBA_OBJECTS)
| Name of the object
|
OBJECT_NAME (V$SQL_PLAN)
|
|
OBJECT_NAME (GV$SQL_PLAN)
|
|
OBJECT_NAME (V$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_NAME (DBA_AUDIT_POLICIES)
| Name of the table or view
|
OBJECT_NAME (GV$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_NODE (GV$SQL_PLAN)
|
|
OBJECT_NODE (GV$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_NODE (V$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_NODE (V$SQL_PLAN)
|
|
OBJECT_OWNER (DBA_USTATS)
| Owner of the table or index for which the statistics have been collected
|
OBJECT_OWNER (V$SQL_PLAN)
|
|
OBJECT_OWNER (V$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_OWNER (DBA_ASSOCIATIONS)
| Owner of the object for which the association is being defined
|
OBJECT_OWNER (DBA_POLICY_CONTEXTS)
| Schema of the synonym, table, or view
|
OBJECT_OWNER (GV$SQL_PLAN)
|
|
OBJECT_OWNER (DBA_APPLY_KEY_COLUMNS)
| Owner of the object
|
OBJECT_OWNER (DBA_APPLY_CONFLICT_COLUMNS)
| Owner of the object
|
OBJECT_OWNER (GV$VPD_POLICY)
|
|
OBJECT_OWNER (V$VPD_POLICY)
|
|
OBJECT_OWNER (ALL_APPLY_DML_HANDLERS)
| Owner of the object
|
OBJECT_OWNER (ALL_POLICIES)
| Owner of the synonym, table, or view
|
OBJECT_OWNER (ALL_APPLY_CONFLICT_COLUMNS)
| Owner of the object
|
OBJECT_OWNER (ALL_USTATS)
| Owner of the table or index for which the statistics have been collected
|
OBJECT_OWNER (ALL_ASSOCIATIONS)
| Owner of the object for which the association is being defined
|
OBJECT_OWNER (DBA_POLICIES)
| Owner of the synonym, table, or view
|
OBJECT_OWNER (USER_ASSOCIATIONS)
| Owner of the object for which the association is being defined
|
OBJECT_OWNER (USER_USTATS)
| Owner of the table or index for which the statistics have been collected
|
OBJECT_OWNER (DBA_POLICY_GROUPS)
| Schema of the synonym, table, or view
|
OBJECT_OWNER (ALL_APPLY_KEY_COLUMNS)
| Owner of the object
|
OBJECT_OWNER (ALL_POLICY_CONTEXTS)
| Schema of the synonym, table, or view
|
OBJECT_OWNER (ALL_POLICY_GROUPS)
| Schema of the synonym, table, or view
|
OBJECT_OWNER (GV$SQL_PLAN_STATISTICS_ALL)
|
|
OBJECT_OWNER (DBA_APPLY_DML_HANDLERS)
| Owner of the object
|
OBJECT_RECID (V$DELETED_OBJECT)
|
|
OBJECT_RECID (GV$DELETED_OBJECT)
|
|
OBJECT_REFRESHES (GV$SESSION_OBJECT_CACHE)
|
|
OBJECT_REFRESHES (V$SESSION_OBJECT_CACHE)
|
|
OBJECT_SCHEMA (ALL_AUDIT_POLICIES)
| Owner of the table or view
|
OBJECT_SCHEMA (DBA_FGA_AUDIT_TRAIL)
| Owner of the table or view
|
OBJECT_SCHEMA (DBA_AUDIT_POLICIES)
| Owner of the table or view
|
OBJECT_STAMP (V$DELETED_OBJECT)
|
|
OBJECT_STAMP (GV$DELETED_OBJECT)
|
|
OBJECT_STATUS (V$SQL)
|
|
OBJECT_STATUS (GV$SQL)
|
|
OBJECT_TYPE (USER_PART_KEY_COLUMNS)
|
|
OBJECT_TYPE (ALL_QUEUE_TABLES)
| Name of the payload type for object type payload
|
OBJECT_TYPE (DBA_CACHEABLE_OBJECTS_BASE)
|
|
OBJECT_TYPE (ALL_PROBE_OBJECTS)
|
|
OBJECT_TYPE (DBA_CACHEABLE_NONTABLE_OBJECTS)
|
|
OBJECT_TYPE (USER_REPCAT_TEMPLATE_OBJECTS)
| Type of database object.
|
OBJECT_TYPE (ALL_USTATS)
| Type of the object - Column or Index
|
OBJECT_TYPE (DBA_ASSOCIATIONS)
| Schema type of the object - table, type, package or function
|
OBJECT_TYPE (USER_STORED_SETTINGS)
| Type of the object
|
OBJECT_TYPE (DBA_IAS_OBJECTS_BASE)
|
|
OBJECT_TYPE (ALL_STORED_SETTINGS)
| Type of the object
|
OBJECT_TYPE (ALL_SUBPART_KEY_COLUMNS)
|
|
OBJECT_TYPE (DBA_IAS_OBJECTS_EXP)
|
|
OBJECT_TYPE (USER_SUBPART_KEY_COLUMNS)
|
|
OBJECT_TYPE (USER_ASSOCIATIONS)
| Schema type of the object - table, type, package or function
|
OBJECT_TYPE (V$SEGMENT_STATISTICS)
|
|
OBJECT_TYPE (DBA_ANALYZE_OBJECTS)
|
|
OBJECT_TYPE (DBA_REPCAT_TEMPLATE_OBJECTS)
| Type of database object.
|
OBJECT_TYPE (USER_OBJ_AUDIT_OPTS)
| Type of the object: "TABLE" or "VIEW"
|
OBJECT_TYPE (DBA_PART_KEY_COLUMNS)
|
|
OBJECT_TYPE (USER_USTATS)
| Type of the object - Column or Index
|
OBJECT_TYPE (DBA_OBJ_AUDIT_OPTS)
| Type of the object
|
OBJECT_TYPE (OBJ)
| Type of the object
|
OBJECT_TYPE (DBA_OBJECTS)
| Type of the object
|
OBJECT_TYPE (USER_OBJECTS)
| Type of the object
|
OBJECT_TYPE (DBA_USTATS)
| Type of the object - Column or Index
|
OBJECT_TYPE (DBA_EXP_OBJECTS)
| Type of exported object
|
OBJECT_TYPE (ALL_REPCAT_TEMPLATE_OBJECTS)
| Type of database object.
|
OBJECT_TYPE (DBA_IAS_OBJECTS)
|
|
OBJECT_TYPE (ALL_ASSOCIATIONS)
| Schema type of the object - column, type, package or function
|
OBJECT_TYPE (DBA_QUEUE_TABLES)
| Name of the payload type for object type payload
|
OBJECT_TYPE (DBA_CACHEABLE_OBJECTS)
|
|
OBJECT_TYPE (ALL_OBJECTS)
| Type of the object
|
OBJECT_TYPE (GV$SEGMENT_STATISTICS)
|
|
OBJECT_TYPE (DBA_STORED_SETTINGS)
| Type of the object
|
OBJECT_TYPE (DBA_SUBPART_KEY_COLUMNS)
|
|
OBJECT_TYPE (USER_QUEUE_TABLES)
| Name of the payload type for object type payload
|
OBJECT_TYPE (ALL_PART_KEY_COLUMNS)
|
|
OBJECT_TYPE_ID (DBA_IAS_OBJECTS_BASE)
|
|
OBJ_NAME (DBA_AUDIT_EXISTS)
|
|
OBJ_NAME (DBA_AUDIT_STATEMENT)
|
|
OBJ_NAME (USER_AUDIT_OBJECT)
|
|
OBJ_NAME (USER_AUDIT_TRAIL)
| Name of the object affected by the action
|
OBJ_NAME (USER_AUDIT_STATEMENT)
|
|
OBJ_NAME (DBA_AUDIT_OBJECT)
|
|
OBJ_NAME (DBA_AUDIT_TRAIL)
| Name of the object affected by the action
|
OBJ_PRIVILEGE (USER_AUDIT_TRAIL)
| Object privileges granted/revoked by a GRANT/REVOKE statement
|
OBJ_PRIVILEGE (DBA_AUDIT_TRAIL)
| Object privileges granted/revoked by a GRANT/REVOKE statement
|
OBJ_PRIVILEGE (DBA_AUDIT_EXISTS)
|
|
OBJ_PRIVILEGE (DBA_AUDIT_STATEMENT)
|
|
OBJ_PRIVILEGE (USER_AUDIT_STATEMENT)
|
|
PARENT_OBJECT_TYPE (ALL_REFRESH_DEPENDENCIES)
| Materialized View
|
PINNED_OBJECTS (GV$SESSION_OBJECT_CACHE)
|
|
PINNED_OBJECTS (V$SESSION_OBJECT_CACHE)
|
|
ROW_WAIT_OBJ# (V$SESSION)
|
|
ROW_WAIT_OBJ# (GV$SESSION)
|
|
SECONDARY_OBJECT_NAME (USER_SECONDARY_OBJECTS)
| Name of the secondary object
|
SECONDARY_OBJECT_NAME (DBA_SECONDARY_OBJECTS)
| Name of the secondary object
|
SECONDARY_OBJECT_NAME (ALL_SECONDARY_OBJECTS)
| Name of the secondary object
|
SECONDARY_OBJECT_OWNER (ALL_SECONDARY_OBJECTS)
| Owner of the secondary object
|
SECONDARY_OBJECT_OWNER (USER_SECONDARY_OBJECTS)
| Owner of the secondary object
|
SECONDARY_OBJECT_OWNER (DBA_SECONDARY_OBJECTS)
| Owner of the secondary object
|
SOURCE_OBJECT_NAME (DBA_APPLY_INSTANTIATED_OBJECTS)
| Name of the object at source
|
SOURCE_OBJECT_OWNER (DBA_APPLY_INSTANTIATED_OBJECTS)
| Owner of the object at the source database
|
SOURCE_OBJECT_TYPE (DBA_APPLY_INSTANTIATED_OBJECTS)
| Type of the object at source
|