| Column Name
| Description
|
| ACCOUNT_STATUS (USER_USERS)
|
|
| ACCOUNT_STATUS (DBA_USERS)
|
|
| ADVICE_STATUS (GV$PGA_TARGET_ADVICE)
|
|
| ADVICE_STATUS (V$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| ADVICE_STATUS (V$DB_CACHE_ADVICE)
|
|
| ADVICE_STATUS (GV$DB_CACHE_ADVICE)
|
|
| ADVICE_STATUS (V$PGA_TARGET_ADVICE)
|
|
| ADVICE_STATUS (GV$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| ADVICE_STATUS (V$MTTR_TARGET_ADVICE)
|
|
| ADVICE_STATUS (GV$MTTR_TARGET_ADVICE)
|
|
| DATABASE_STATUS (GV$INSTANCE)
|
|
| DATABASE_STATUS (V$INSTANCE)
|
|
| DOMIDX_STATUS (IND)
| Is the indextype of the domain index valid
|
| DOMIDX_STATUS (USER_INDEXES)
| Is the indextype of the domain index valid
|
| DOMIDX_STATUS (DBA_INDEXES)
| Is the indextype of the domain index valid
|
| DOMIDX_STATUS (ALL_INDEXES)
| Is the indextype of the domain index valid
|
| EXTENSION_STATUS (DBA_REPEXTENSIONS)
| Status of replication extension
|
| FILE_STATUS (GV$MAP_FILE)
|
|
| FILE_STATUS (V$MAP_FILE)
|
|
| FREEZE_STATUS (USER_WORKSPACES)
|
|
| FREEZE_STATUS (DBA_WORKSPACES)
|
|
| FREEZE_STATUS (ALL_WORKSPACES)
|
|
| FUNCIDX_STATUS (ALL_INDEXES)
| Is the Function-based Index DISABLED or ENABLED?
|
| FUNCIDX_STATUS (IND)
| Is the Function-based Index DISABLED or ENABLED?
|
| FUNCIDX_STATUS (USER_INDEXES)
| Is the Function-based Index DISABLED or ENABLED?
|
| FUNCIDX_STATUS (DBA_INDEXES)
| Is the Function-based Index DISABLED or ENABLED?
|
| GENERATION_STATUS (DBA_REPOBJECT)
| Status of whether the object needs to generate replication packages
|
| GENERATION_STATUS (USER_REPOBJECT)
| Status of whether the object needs to generate replication packages
|
| GENERATION_STATUS (ALL_REPOBJECT)
| Status of whether the object needs to generate replication packages
|
| GUARD_STATUS (GV$DATABASE)
|
|
| GUARD_STATUS (V$DATABASE)
|
|
| MASTER_STATUS (DBA_REPSITES_NEW)
| Instantiation status of the new master
|
| OBJECT_STATUS (V$SQL)
|
|
| OBJECT_STATUS (GV$SQL)
|
|
| ONLINE_STATUS (V$RECOVER_FILE)
|
|
| ONLINE_STATUS (GV$RECOVER_FILE)
|
|
| PDDL_STATUS (V$SESSION)
|
|
| PDDL_STATUS (GV$SESSION)
|
|
| PDML_STATUS (GV$SESSION)
|
|
| PDML_STATUS (V$SESSION)
|
|
| PQ_STATUS (V$SESSION)
|
|
| PQ_STATUS (GV$SESSION)
|
|
| PREVIOUS_LOG_STATUS (V$RECOVERY_STATUS)
|
|
| PREVIOUS_LOG_STATUS (GV$RECOVERY_STATUS)
|
|
| RESOLVE_STATUS (ALL_WORKSPACES)
|
|
| RESOLVE_STATUS (DBA_WORKSPACES)
|
|
| RESOLVE_STATUS (USER_WORKSPACES)
|
|
| SESSION_STATUS (V$STATISTICS_LEVEL)
|
|
| SESSION_STATUS (GV$STATISTICS_LEVEL)
|
|
| STATUS (ALL_CONSTRAINTS)
| Enforcement status of constraint - ENABLED or DISABLED
|
| STATUS (ALL_IND_SUBPARTITIONS)
|
|
| STATUS (V$BACKUP)
|
|
| STATUS (V$LOG)
|
|
| STATUS (GV$TRANSACTION)
|
|
| STATUS (DBA_APPLY)
| Status of the apply process: DISABLED, ENABLED, ABORTED
|
| STATUS (DBA_REPCAT_TEMPLATE_SITES)
| Status of the instantiation at the site.
|
| STATUS (GV$BH)
|
|
| STATUS (V$SQL_CURSOR)
|
|
| STATUS (USER_REPRESOL_STATS_CONTROL)
| Status of statistics collection: ACTIVE, CANCELLED
|
| STATUS (GV$LOGMNR_PARAMETERS)
|
|
| STATUS (USER_IND_PARTITIONS)
|
|
| STATUS (GV$BACKUP)
|
|
| STATUS (DBA_REPGROUP)
| If the site is a master, the master's status
|
| STATUS (GV$DISPATCHER)
|
|
| STATUS (V$BACKUP_ASYNC_IO)
|
|
| STATUS (GV$CONTROLFILE)
|
|
| STATUS (USER_REPCATLOG)
| Status of the request at this database
|
| STATUS (ALL_LIBRARIES)
| Status of the library
|
| STATUS (V$THREAD)
|
|
| STATUS (USER_TYPE_VERSIONS)
| Status of the type
|
| STATUS (GV$DATAFILE_COPY)
|
|
| STATUS (DBA_IND_PARTITIONS)
|
|
| STATUS (DBA_TABLESPACES)
| Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"
|
| STATUS (ALL_OBJECTS)
| Status of the object
|
| STATUS (GV$BACKUP_SYNC_IO)
|
|
| STATUS (V$DATAFILE_HEADER)
|
|
| STATUS (GV$RESUMABLE)
|
|
| STATUS (V$CONTROLFILE)
|
|
| STATUS (ALL_IND_PARTITIONS)
|
|
| STATUS (GV$BACKUP_PIECE)
|
|
| STATUS (GV$LOGSTDBY)
|
|
| STATUS (V$LOGSTDBY)
|
|
| STATUS (GV$THREAD)
|
|
| STATUS (USER_REGISTRY)
|
|
| STATUS (DBA_LIBRARIES)
| Status of the library
|
| STATUS (GV$DLM_TRAFFIC_CONTROLLER)
|
|
| STATUS (V$PQ_SLAVE)
|
|
| STATUS (DBA_ROLLBACK_SEGS)
| Rollback segment status
|
| STATUS (GV$ARCHIVE_DEST_STATUS)
|
|
| STATUS (V$ARCHIVE_DEST)
|
|
| STATUS (GV$SHARED_SERVER)
|
|
| STATUS (ALL_CAPTURE)
| Status of the capture process: DISABLED, ENABLED, ABORTED
|
| STATUS (USER_INDEXES)
| Whether the non-partitioned index is in USABLE or not
|
| STATUS (USER_TABLESPACES)
| Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"
|
| STATUS (GV$SESSION)
|
|
| STATUS (DBA_UNDO_EXTENTS)
| Transaction Status of the undo in the extent
|
| STATUS (V$LOGMNR_CONTENTS)
|
|
| STATUS (GV$CIRCUIT)
|
|
| STATUS (USER_REPCAT_TEMPLATE_SITES)
| Status of the instantiation at the site.
|
| STATUS (V$INSTANCE)
|
|
| STATUS (V$LOGMNR_LOGS)
|
|
| STATUS (DBA_IND_SUBPARTITIONS)
|
|
| STATUS (ALL_REPOBJECT)
| Status of the last create or alter request on the local object
|
| STATUS (DBA_RESUMABLE)
| Status of this resumable session
|
| STATUS (V$SHARED_SERVER)
|
|
| STATUS (V$PROXY_ARCHIVEDLOG)
|
|
| STATUS (USER_TRIGGERS)
| If DISABLED then trigger will not fire
|
| STATUS (OBJ)
| Status of the object
|
| STATUS (GV$STANDBY_LOG)
|
|
| STATUS (DBA_REPCATLOG)
| Status of the request at this database
|
| STATUS (USER_REPOBJECT)
| Status of the last create or alter request on the local object
|
| STATUS (DBA_DATA_FILES)
| File status: "INVALID" or "AVAILABLE"
|
| STATUS (GV$LOG)
|
|
| STATUS (DBA_TEMP_FILES)
| File status: "AVAILABLE"
|
| STATUS (DBA_REPCAT)
|
|
| STATUS (ALL_TRIGGERS)
| If DISABLED then trigger will not fire
|
| STATUS (V$ROLLSTAT)
|
|
| STATUS (DBA_RSRC_PLANS)
| PENDING if it is part of the pending area, ACTIVE otherwise
|
| STATUS (GV$DATAFILE_HEADER)
|
|
| STATUS (GV$PX_PROCESS)
|
|
| STATUS (USER_CONSTRAINTS)
| Enforcement status of constraint - ENABLED or DISABLED
|
| STATUS (V$PROXY_DATAFILE)
|
|
| STATUS (DBA_SUBSCRIPTIONS)
|
|
| STATUS (V$SGA_RESIZE_OPS)
|
|
| STATUS (V$STANDBY_LOG)
|
|
| STATUS (GV$INSTANCE)
|
|
| STATUS (GV$ARCHIVE_PROCESSES)
|
|
| STATUS (DBA_REPOBJECT)
| Status of the last create or alter request on the local object
|
| STATUS (V$LOGMNR_DICTIONARY)
|
|
| STATUS (DBA_REPRESOL_STATS_CONTROL)
| Status of statistics collection: ACTIVE, CANCELLED
|
| STATUS (ALL_APPLY)
| Status of the apply process: DISABLED, ENABLED, ABORTED
|
| STATUS (DBA_CONSTRAINTS)
| Enforcement status of constraint - ENABLED or DISABLED
|
| STATUS (DBA_TYPE_VERSIONS)
| Status of the type
|
| STATUS (V$ARCHIVE_DEST_STATUS)
|
|
| STATUS (V$LOGFILE)
|
|
| STATUS (USER_REPCAT)
|
|
| STATUS (ALL_REPCATLOG)
| Status of the request at this database
|
| STATUS (ALL_PROBE_OBJECTS)
|
|
| STATUS (USER_OBJECTS)
| Status of the object
|
| STATUS (DBA_TRIGGERS)
| If DISABLED then trigger will not fire
|
| STATUS (GV$SGA_RESIZE_OPS)
|
|
| STATUS (GV$PROXY_DATAFILE)
|
|
| STATUS (V$RECOVERY_FILE_STATUS)
|
|
| STATUS (V$SESSION)
|
|
| STATUS (V$LOGMNR_PARAMETERS)
|
|
| STATUS (DBA_REGISTRY)
|
|
| STATUS (V$DLM_TRAFFIC_CONTROLLER)
|
|
| STATUS (USER_SUBSCRIPTIONS)
|
|
| STATUS (V$TRANSACTION)
|
|
| STATUS (ALL_REPCAT)
|
|
| STATUS (V$CIRCUIT)
|
|
| STATUS (DBA_RSRC_CONSUMER_GROUPS)
| PENDING if it is part of the pending area, ACTIVE otherwise
|
| STATUS (V$DATAFILE_COPY)
|
|
| STATUS (USER_SNAPSHOTS)
| The status of the contents of the snapshot
|
| STATUS (V$RESUMABLE)
|
|
| STATUS (DBA_WORKSPACE_SESSIONS)
|
|
| STATUS (V$TEMPFILE)
|
|
| STATUS (V$DATAFILE)
|
|
| STATUS (V$ARCHIVED_LOG)
|
|
| STATUS (GV$BACKUP_ASYNC_IO)
|
|
| STATUS (V$ARCHIVE_PROCESSES)
|
|
| STATUS (V$BACKUP_SYNC_IO)
|
|
| STATUS (ALL_REPCAT_TEMPLATE_SITES)
| Status of the instantiation at the site.
|
| STATUS (GV$SQL_CURSOR)
|
|
| STATUS (DBA_CAPTURE)
| Status of the capture process: DISABLED, ENABLED, ABORTED
|
| STATUS (IND)
| Whether the non-partitioned index is in USABLE or not
|
| STATUS (GV$LOGMNR_LOGS)
|
|
| STATUS (DBA_REGISTRY_HIERARCHY)
|
|
| STATUS (V$MANAGED_STANDBY)
|
|
| STATUS (USER_RESUMABLE)
| Status of this resumable session
|
| STATUS (GV$PROXY_ARCHIVEDLOG)
|
|
| STATUS (V$DISPATCHER)
|
|
| STATUS (DBA_OBJECTS)
| Status of the object
|
| STATUS (USER_LIBRARIES)
| Status of the library
|
| STATUS (ALL_INDEXES)
| Whether the non-partitioned index is in USABLE or not
|
| STATUS (USER_IND_SUBPARTITIONS)
|
|
| STATUS (GV$DATAFILE)
|
|
| STATUS (ALL_REPRESOL_STATS_CONTROL)
| Status of statistics collection: ACTIVE, CANCELLED
|
| STATUS (GV$MANAGED_STANDBY)
|
|
| STATUS (GV$RECOVERY_FILE_STATUS)
|
|
| STATUS (GV$PQ_SLAVE)
|
|
| STATUS (DBA_SNAPSHOTS)
| The status of the contents of the snapshot
|
| STATUS (DBA_INDEXES)
| Whether non-partitioned index is in UNUSABLE state or not
|
| STATUS (DBA_RSRC_PLAN_DIRECTIVES)
| PENDING if it is part of the pending area, ACTIVE otherwise
|
| STATUS (GV$LOGFILE)
|
|
| STATUS (ALL_REPGROUP)
| If the site is a master, the master's status
|
| STATUS (DBA_LOGSTDBY_EVENTS)
| A text string describing the event
|
| STATUS (GV$ARCHIVED_LOG)
|
|
| STATUS (GV$ROLLSTAT)
|
|
| STATUS (V$BACKUP_PIECE)
|
|
| STATUS (V$BH)
|
|
| STATUS (GV$LOGMNR_CONTENTS)
|
|
| STATUS (ALL_SNAPSHOTS)
| The status of the contents of the snapshot
|
| STATUS (GV$ARCHIVE_DEST)
|
|
| STATUS (USER_REPGROUP)
| If site is master, the master's status
|
| STATUS (ALL_SUBSCRIPTIONS)
|
|
| STATUS (ALL_TYPE_VERSIONS)
| Status of the type
|
| STATUS (GV$LOGMNR_DICTIONARY)
|
|
| STATUS (V$PX_PROCESS)
|
|
| STATUS (GV$TEMPFILE)
|
|
| STATUS_CODE (DBA_LOGSTDBY_EVENTS)
| A number describing the event
|
| STATUS_CODE (V$LOGSTDBY)
|
|
| STATUS_CODE (GV$LOGSTDBY)
|
|
| STATUS_UPDATE_DATE (DBA_REPRESOL_STATS_CONTROL)
| Timestamp for which the status was last updated
|
| STATUS_UPDATE_DATE (ALL_REPRESOL_STATS_CONTROL)
| Timestamp for which the status was last updated
|
| STATUS_UPDATE_DATE (USER_REPRESOL_STATS_CONTROL)
| Timestamp for which the status was last updated
|
| SWITCHOVER_STATUS (V$DATABASE)
|
|
| SWITCHOVER_STATUS (GV$DATABASE)
|
|
| SYSTEM_STATUS (GV$STATISTICS_LEVEL)
|
|
| SYSTEM_STATUS (V$STATISTICS_LEVEL)
|
|