Column Name
| Description
|
AGENT_ID (GV$HS_SESSION)
|
|
AGENT_ID (V$HS_AGENT)
|
|
AGENT_ID (GV$HS_AGENT)
|
|
AGENT_ID (V$HS_SESSION)
|
|
BLOCK_ID (DBA_EXTENTS)
| Starting block number of the extent
|
BLOCK_ID (GV$TEMP_EXTENT_MAP)
|
|
BLOCK_ID (DBA_FREE_SPACE)
| Starting block number of the extent
|
BLOCK_ID (DBA_ROLLBACK_SEGS)
| ID number of the block containing the segment header
|
BLOCK_ID (USER_FREE_SPACE)
| Starting block number of the extent
|
BLOCK_ID (DBA_DMT_FREE_SPACE)
| Starting block number of the extent
|
BLOCK_ID (DBA_UNDO_EXTENTS)
| Starting block number of the extent
|
BLOCK_ID (DBA_LMT_FREE_SPACE)
| Starting block number of the extent
|
BLOCK_ID (V$TEMP_EXTENT_MAP)
|
|
CACHE_ID (GV$SUBCACHE)
|
|
CACHE_ID (V$SUBCACHE)
|
|
CLIENT_ID (DBA_AUDIT_EXISTS)
|
|
CLIENT_ID (USER_AUDIT_OBJECT)
|
|
CLIENT_ID (GV$LOGMNR_SESSION)
|
|
CLIENT_ID (USER_AUDIT_TRAIL)
| Client identifier in each Oracle session
|
CLIENT_ID (USER_AUDIT_SESSION)
|
|
CLIENT_ID (USER_AUDIT_STATEMENT)
|
|
CLIENT_ID (DBA_AUDIT_SESSION)
|
|
CLIENT_ID (V$LOGMNR_SESSION)
|
|
CLIENT_ID (DBA_AUDIT_TRAIL)
| Client identifier in each Oracle session
|
CLIENT_ID (DBA_AUDIT_OBJECT)
|
|
CLIENT_ID (DBA_AUDIT_STATEMENT)
|
|
CLIENT_ID (DBA_FGA_AUDIT_TRAIL)
| Client identifier in each Oracle session
|
CLIENT_IDENTIFIER (GV$GLOBALCONTEXT)
|
|
CLIENT_IDENTIFIER (GV$SESSION)
|
|
CLIENT_IDENTIFIER (V$GLOBALCONTEXT)
|
|
CLIENT_IDENTIFIER (V$SESSION)
|
|
COLUMN_ID (DBA_TAB_COLUMNS)
| Sequence number of the column as created
|
COLUMN_ID (COLS)
| Sequence number of the column as created
|
COLUMN_ID (ALL_TAB_COLUMNS)
| Sequence number of the column as created
|
COLUMN_ID (USER_TAB_COLS)
| Sequence number of the column as created
|
COLUMN_ID (ALL_TAB_COLS)
| Sequence number of the column as created
|
COLUMN_ID (DBA_TAB_COLS)
| Sequence number of the column as created
|
COLUMN_ID (USER_TAB_COLUMNS)
| Sequence number of the column as created
|
COMP_ID (USER_REGISTRY)
|
|
COMP_ID (DBA_REGISTRY_HIERARCHY)
|
|
COMP_ID (DBA_REGISTRY)
|
|
COORD_INSTANCE_ID (DBA_RESUMABLE)
| Instance number of parallel query coordinator
|
COORD_INSTANCE_ID (USER_RESUMABLE)
| Instance number of parallel query coordinator
|
COORD_SESSION_ID (USER_RESUMABLE)
| Session number of parallel query coordinator
|
COORD_SESSION_ID (DBA_RESUMABLE)
| Session number of parallel query coordinator
|
DATA_OBJECT_ID (ALL_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 (DBA_OBJECTS)
| Object number of the segment which contains the object
|
DATA_OBJECT_ID (USER_OBJECTS)
| Object number of the segment which contains the object
|
DATA_OBJECT_ID (ALL_PROBE_OBJECTS)
|
|
DB_ID (GV$LOGMNR_DICTIONARY)
|
|
DB_ID (GV$LOGMNR_LOGS)
|
|
DB_ID (V$LOGMNR_SESSION)
|
|
DB_ID (V$LOGMNR_DICTIONARY)
|
|
DB_ID (V$LOGMNR_LOGS)
|
|
DB_ID (V$LOGMNR_LOGFILE)
|
|
DB_ID (GV$LOGMNR_SESSION)
|
|
DB_ID (GV$LOGMNR_LOGFILE)
|
|
DEST_ID (V$ARCHIVE_DEST_STATUS)
|
|
DEST_ID (V$ARCHIVED_LOG)
|
|
DEST_ID (GV$ARCHIVED_LOG)
|
|
DEST_ID (V$ARCHIVE_DEST)
|
|
DEST_ID (GV$DATAGUARD_STATUS)
|
|
DEST_ID (GV$ARCHIVE_DEST)
|
|
DEST_ID (GV$ARCHIVE_DEST_STATUS)
|
|
DEST_ID (V$DATAGUARD_STATUS)
|
|
DIM_KEY_ID (ALL_DIM_JOIN_KEY)
| Join key ID (unique within a dimension)
|
DIM_KEY_ID (DBA_DIM_JOIN_KEY)
| Join key ID (unique within a dimension)
|
DIM_KEY_ID (USER_DIM_JOIN_KEY)
| Join key ID (unique within a dimension)
|
EXCEPTION_ID (DBA_REPCAT_EXCEPTIONS)
| Internal primary key of the exceptions table.
|
EXTENSION_ID (DBA_REPEXTENSIONS)
| Globally unique identifier for replication extension
|
EXTENSION_ID (DBA_REPSITES_NEW)
| Globally unique identifier for replication extension
|
EXTENT_ID (DBA_UNDO_EXTENTS)
| Extent number in the segment
|
EXTENT_ID (DBA_EXTENTS)
| Extent number in the segment
|
EXTENT_ID (USER_EXTENTS)
| Extent number in the segment
|
EXTENT_ID (DBA_LMT_USED_EXTENTS)
| Extent number in the segment
|
EXTENT_ID (DBA_DMT_USED_EXTENTS)
| Extent number in the segment
|
FDS_CLASS_ID (V$HS_AGENT)
|
|
FDS_CLASS_ID (GV$HS_AGENT)
|
|
FDS_INST_ID (V$HS_AGENT)
|
|
FDS_INST_ID (GV$HS_AGENT)
|
|
FILE_ID (V$GCSPFMASTER_INFO)
|
|
FILE_ID (V$TEMP_SPACE_HEADER)
|
|
FILE_ID (DBA_DMT_FREE_SPACE)
| ID number of the file containing the extent
|
FILE_ID (DBA_ROLLBACK_SEGS)
| ID number of the file containing the segment header
|
FILE_ID (DBA_DATA_FILES)
| ID of the database data file
|
FILE_ID (DBA_EXTENTS)
| Name of the file containing the extent
|
FILE_ID (GV$TEMP_SPACE_HEADER)
|
|
FILE_ID (GV$TEMP_EXTENT_MAP)
|
|
FILE_ID (V$TEMP_EXTENT_MAP)
|
|
FILE_ID (DBA_UNDO_EXTENTS)
| Name of the file containing the extent
|
FILE_ID (DBA_FREE_SPACE)
| ID number of the file containing the extent
|
FILE_ID (DBA_TEMP_FILES)
| ID of the database temp file
|
FILE_ID (V$TEMP_EXTENT_POOL)
|
|
FILE_ID (GV$GCSPFMASTER_INFO)
|
|
FILE_ID (GV$TEMP_EXTENT_POOL)
|
|
FILE_ID (USER_FREE_SPACE)
| ID number of the file containing the extent
|
FILE_ID (DBA_LMT_FREE_SPACE)
| ID number of the file containing the extent
|
FLAVOR_ID (DBA_REPCAT_TEMPLATE_OBJECTS)
| Foreign key to the REPCAT$_FLAVORS table.
|
FLAVOR_ID (USER_REPCAT_TEMPLATE_OBJECTS)
| Foreign key to the REPCAT$_FLAVORS table.
|
FLAVOR_ID (DBA_REPFLAVORS)
| Flavor identifier, unique within object group
|
FLAVOR_ID (ALL_REPFLAVORS)
| Flavor identifier, unique within object group
|
FLAVOR_ID (USER_REPFLAVORS)
| Flavor identifier, unique within object group
|
FLAVOR_ID (ALL_REPCAT_TEMPLATE_OBJECTS)
| Foreign key to the REPCAT$_FLAVORS table.
|
GLOBAL_TRAN_ID (DBA_2PC_PENDING)
| globally unique transaction id
|
GROUP_ID (GV$DLM_LOCKS)
|
|
GROUP_ID (V$DLM_LOCKS)
|
|
GROUP_ID (GV$GES_BLOCKING_ENQUEUE)
|
|
GROUP_ID (GV$DLM_ALL_LOCKS)
|
|
GROUP_ID (V$GES_ENQUEUE)
|
|
GROUP_ID (V$DLM_ALL_LOCKS)
|
|
GROUP_ID (V$GES_BLOCKING_ENQUEUE)
|
|
GROUP_ID (GV$GES_ENQUEUE)
|
|
HS_SESSION_ID (V$HS_SESSION)
|
|
HS_SESSION_ID (GV$HS_PARAMETER)
|
|
HS_SESSION_ID (V$HS_PARAMETER)
|
|
HS_SESSION_ID (GV$HS_SESSION)
|
|
HV_ID (GV$GCSHVMASTER_INFO)
|
|
HV_ID (V$HVMASTER_INFO)
|
|
HV_ID (V$GCSHVMASTER_INFO)
|
|
HV_ID (GV$HVMASTER_INFO)
|
|
IAS_TEMPLATE_ID (DBA_IAS_GEN_STMTS_EXP)
|
|
IAS_TEMPLATE_ID (DBA_IAS_PREGEN_STMTS)
|
|
IAS_TEMPLATE_ID (DBA_IAS_TEMPLATES)
|
|
IAS_TEMPLATE_ID (DBA_IAS_POSTGEN_STMTS)
|
|
ID (GV$DB_CACHE_ADVICE)
|
|
ID (V$BUFFER_POOL_STATISTICS)
|
|
ID (V$MAP_FILE_IO_STACK)
|
|
ID (USER_REPOBJECT)
| Identifier of the local object
|
ID (V$BUFFER_POOL)
|
|
ID (ALL_REPOBJECT)
| Identifier of the local object
|
ID (GV$SQL_PLAN_STATISTICS_ALL)
|
|
ID (ALL_REPCOLUMN)
| ID of the replicated column
|
ID (GV$SQL_PLAN)
|
|
ID (V$SQL_PLAN)
|
|
ID (GV$BUFFER_POOL)
|
|
ID (USER_REPCATLOG)
| Identifying number of repcat log record
|
ID (ALL_REPCATLOG)
| Identifying number of repcat log record
|
ID (V$DB_CACHE_ADVICE)
|
|
ID (GV$MAP_FILE_IO_STACK)
|
|
ID (USER_REPCOLUMN)
| ID of the replicated column
|
ID (DBA_REPCOLUMN)
| ID of the replicated column
|
ID (DBA_REPCATLOG)
| Identifying number of repcat log record
|
ID (DBA_REPOBJECT)
| Identifier of the local object
|
ID (V$SQL_PLAN_STATISTICS_ALL)
|
|
ID (GV$BUFFER_POOL_STATISTICS)
|
|
ID1 (V$GLOBAL_BLOCKED_LOCKS)
|
|
ID1 (GV$TRANSACTION_ENQUEUE)
|
|
ID1 (GV$RESOURCE)
|
|
ID1 (GV$GLOBAL_BLOCKED_LOCKS)
|
|
ID1 (V$LOCK)
|
|
ID1 (GV$LOCK)
|
|
ID1 (V$RESOURCE)
|
|
ID1 (GV$ENQUEUE_LOCK)
|
|
ID1 (V$TRANSACTION_ENQUEUE)
|
|
ID1 (V$ENQUEUE_LOCK)
|
|
ID2 (GV$ENQUEUE_LOCK)
|
|
ID2 (V$LOCK)
|
|
ID2 (V$ENQUEUE_LOCK)
|
|
ID2 (V$GLOBAL_BLOCKED_LOCKS)
|
|
ID2 (GV$GLOBAL_BLOCKED_LOCKS)
|
|
ID2 (V$RESOURCE)
|
|
ID2 (GV$RESOURCE)
|
|
ID2 (V$TRANSACTION_ENQUEUE)
|
|
ID2 (GV$TRANSACTION_ENQUEUE)
|
|
ID2 (GV$LOCK)
|
|
INSTANCE_ID (USER_RESUMABLE)
| Instance ID of this resumable session
|
INSTANCE_ID (DBA_RESUMABLE)
| Instance ID of this resumable session
|
INST_ID (GV$MAP_FILE_EXTENT)
|
|
INST_ID (GV$DATAFILE_COPY)
|
|
INST_ID (GV$SQL_WORKAREA_HISTOGRAM)
|
|
INST_ID (GV$LOGHIST)
|
|
INST_ID (GV$SQL_WORKAREA_ACTIVE)
|
|
INST_ID (GV$CONTROLFILE)
|
|
INST_ID (GV$ARCHIVE_DEST)
|
|
INST_ID (GV$SQLTEXT)
|
|
INST_ID (GV$OBSOLETE_PARAMETER)
|
|
INST_ID (X$KSPPSV)
|
|
INST_ID (X$KSPPI)
|
|
INST_ID (GV$OPEN_CURSOR)
|
|
INST_ID (GV$TEMP_EXTENT_MAP)
|
|
INST_ID (GV$DATABASE_INCARNATION)
|
|
INST_ID (GV$BACKUP_SYNC_IO)
|
|
INST_ID (GV$BACKUP)
|
|
INST_ID (GV$GLOBAL_TRANSACTION)
|
|
INST_ID (GV$CLASS_CACHE_TRANSFER)
|
|
INST_ID (GV$TEMP_EXTENT_POOL)
|
|
INST_ID (GV$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
INST_ID (GV$RESUMABLE)
|
|
INST_ID (GV$MAP_FILE_IO_STACK)
|
|
INST_ID (GV$BGPROCESS)
|
|
INST_ID (GV$DISPATCHER)
|
|
INST_ID (GV$LOADISTAT)
|
|
INST_ID (GV$REPLPROP)
|
|
INST_ID (GV$RSRC_PLAN_CPU_MTH)
|
|
INST_ID (GV$PARAMETER2)
|
|
INST_ID (GV$LOG_HISTORY)
|
|
INST_ID (GV$CLASS_PING)
|
|
INST_ID (X$KSQST)
|
|
INST_ID (GV$MAP_EXT_ELEMENT)
|
|
INST_ID (GV$FAST_START_TRANSACTIONS)
|
|
INST_ID (GV$DLM_ALL_LOCKS)
|
|
INST_ID (GV$_LOCK)
|
|
INST_ID (GV$BACKUP_CORRUPTION)
|
|
INST_ID (GV$EVENT_NAME)
|
|
INST_ID (GV$MLS_PARAMETERS)
|
|
INST_ID (GV$THREAD)
|
|
INST_ID (GV$SESSTAT)
|
|
INST_ID (GV$ROWCACHE_SUBORDINATE)
|
|
INST_ID (GV$LATCHNAME)
|
|
INST_ID (GV$RECOVERY_PROGRESS)
|
|
INST_ID (GV$LOGMNR_CONTENTS)
|
|
INST_ID (GV$MYSTAT)
|
|
INST_ID (GV$SPPARAMETER)
|
|
INST_ID (GV$LATCH_MISSES)
|
|
INST_ID (GV$DB_OBJECT_CACHE)
|
|
INST_ID (GV$SQL_SHARED_CURSOR)
|
|
INST_ID (GV$DLM_TRAFFIC_CONTROLLER)
|
|
INST_ID (GV$NLS_VALID_VALUES)
|
|
INST_ID (GV$SESSION_LONGOPS)
|
|
INST_ID (GV$SQL_WORKAREA)
|
|
INST_ID (GV$ROLLSTAT)
|
|
INST_ID (GV$TYPE_SIZE)
|
|
INST_ID (GV$REPLQUEUE)
|
|
INST_ID (GV$ENQUEUE_STAT)
|
|
INST_ID (GV$BH)
|
|
INST_ID (GV$DISPATCHER_RATE)
|
|
INST_ID (GV$PQ_SESSTAT)
|
|
INST_ID (GV$ARCHIVE_DEST_STATUS)
|
|
INST_ID (GV$RESOURCE_LIMIT)
|
|
INST_ID (GV$PQ_TQSTAT)
|
|
INST_ID (GV$ARCHIVED_LOG)
|
|
INST_ID (GV$BACKUP_ASYNC_IO)
|
|
INST_ID (GV$PX_SESSION)
|
|
INST_ID (GV$TRANSACTION)
|
|
INST_ID (GV$SQL_PLAN_STATISTICS_ALL)
|
|
INST_ID (GV$PARAMETER)
|
|
INST_ID (GV$COMPATSEG)
|
|
INST_ID (GV$GES_ENQUEUE)
|
|
INST_ID (GV$SGASTAT)
|
|
INST_ID (GV$TEMPFILE)
|
|
INST_ID (GV$SGA)
|
|
INST_ID (GV$SESSION)
|
|
INST_ID (GV$ACTIVE_SESS_POOL_MTH)
|
|
INST_ID (GV$LOCKED_OBJECT)
|
|
INST_ID (GV$PX_PROCESS_SYSSTAT)
|
|
INST_ID (GV$FAST_START_SERVERS)
|
|
INST_ID (GV$AW_OLAP)
|
|
INST_ID (GV$STREAMS_CAPTURE)
|
|
INST_ID (GV$DLM_LOCKS)
|
|
INST_ID (GV$PGA_TARGET_ADVICE)
|
|
INST_ID (GV$SESS_IO)
|
|
INST_ID (GV$LOCK_ACTIVITY)
|
|
INST_ID (GV$ARCHIVE)
|
|
INST_ID (GV$MAP_LIBRARY)
|
|
INST_ID (GV$VERSION)
|
|
INST_ID (GV$SYSSTAT)
|
|
INST_ID (GV$INDEXED_FIXED_COLUMN)
|
|
INST_ID (GV$DATABASE)
|
|
INST_ID (GV$SQL_BIND_METADATA)
|
|
INST_ID (GV$LATCH)
|
|
INST_ID (GV$HS_SESSION)
|
|
INST_ID (GV$LOGMNR_DICTIONARY)
|
|
INST_ID (GV$SQL_PLAN)
|
|
INST_ID (GV$FILESTAT)
|
|
INST_ID (GV$CIRCUIT)
|
|
INST_ID (GV$CR_BLOCK_SERVER)
|
|
INST_ID (GV$RESOURCE)
|
|
INST_ID (GV$FIXED_VIEW_DEFINITION)
|
|
INST_ID (GV$DB_CACHE_ADVICE)
|
|
INST_ID (GV$LICENSE)
|
|
INST_ID (GV$SEGSTAT)
|
|
INST_ID (GV$SESSION_CURSOR_CACHE)
|
|
INST_ID (GV$MAP_SUBELEMENT)
|
|
INST_ID (GV$STREAMS_APPLY_COORDINATOR)
|
|
INST_ID (GV$SEGMENT_STATISTICS)
|
|
INST_ID (GV$BUFFER_POOL_STATISTICS)
|
|
INST_ID (GV$DLM_CONVERT_REMOTE)
|
|
INST_ID (GV$DLM_CONVERT_LOCAL)
|
|
INST_ID (GV$DATAFILE)
|
|
INST_ID (GV$LOGMNR_REGION)
|
|
INST_ID (GV$LOGMNR_SESSION)
|
|
INST_ID (GV$INSTANCE_RECOVERY)
|
|
INST_ID (GV$SESSION_EVENT)
|
|
INST_ID (GV$WAITSTAT)
|
|
INST_ID (GV$LOGMNR_TRANSACTION)
|
|
INST_ID (GV$LOGMNR_STATS)
|
|
INST_ID (GV$PWFILE_USERS)
|
|
INST_ID (GV$DLM_LATCH)
|
|
INST_ID (GV$FIXED_TABLE)
|
|
INST_ID (GV$LOCKS_WITH_COLLISIONS)
|
|
INST_ID (GV$TEMPSEG_USAGE)
|
|
INST_ID (GV$PX_SESSTAT)
|
|
INST_ID (GV$BACKUP_SPFILE)
|
|
INST_ID (GV$SYSTEM_PARAMETER2)
|
|
INST_ID (GV$SESSION_CONNECT_INFO)
|
|
INST_ID (GV$AW_SESSION_INFO)
|
|
INST_ID (GV$BACKUP_SET)
|
|
INST_ID (GV$BACKUP_PIECE)
|
|
INST_ID (GV$HVMASTER_INFO)
|
|
INST_ID (GV$RSRC_PLAN)
|
|
INST_ID (GV$STANDBY_LOG)
|
|
INST_ID (GV$SEGSTAT_NAME)
|
|
INST_ID (GV$DLM_RESS)
|
|
INST_ID (GV$SHARED_SERVER)
|
|
INST_ID (GV$PROXY_ARCHIVEDLOG)
|
|
INST_ID (GV$AQ1)
|
|
INST_ID (GV$SQLAREA)
|
|
INST_ID (GV$NLS_PARAMETERS)
|
|
INST_ID (GV$SYSTEM_CURSOR_CACHE)
|
|
INST_ID (GV$LOG)
|
|
INST_ID (GV$MANAGED_STANDBY)
|
|
INST_ID (GV$DBFILE)
|
|
INST_ID (GV$ROWCACHE)
|
|
INST_ID (GV$PARALLEL_DEGREE_LIMIT_MTH)
|
|
INST_ID (GV$LIBRARYCACHE)
|
|
INST_ID (GV$SHARED_POOL_ADVICE)
|
|
INST_ID (V$ENQUEUE_STAT)
|
|
INST_ID (GV$HS_AGENT)
|
|
INST_ID (GV$ACCESS)
|
|
INST_ID (GV$TIMER)
|
|
INST_ID (GV$PX_PROCESS)
|
|
INST_ID (GV$DATAFILE_HEADER)
|
|
INST_ID (GV$INSTANCE)
|
|
INST_ID (GV$RSRC_CONSUMER_GROUP)
|
|
INST_ID (GV$MAP_COMP_LIST)
|
|
INST_ID (GV$SORT_SEGMENT)
|
|
INST_ID (GV$UNDOSTAT)
|
|
INST_ID (GV$TRANSACTION_ENQUEUE)
|
|
INST_ID (GV$SGA_CURRENT_RESIZE_OPS)
|
|
INST_ID (GV$MVREFRESH)
|
|
INST_ID (GV$ARCHIVE_PROCESSES)
|
|
INST_ID (GV$COMPATIBILITY)
|
|
INST_ID (GV$LOGMNR_CALLBACK)
|
|
INST_ID (GV$SYSTEM_PARAMETER)
|
|
INST_ID (GV$DB_PIPES)
|
|
INST_ID (GV$ENQUEUE_LOCK)
|
|
INST_ID (GV$SORT_USAGE)
|
|
INST_ID (GV$STATISTICS_LEVEL)
|
|
INST_ID (GV$ROWCACHE_PARENT)
|
|
INST_ID (GV$SHARED_SERVER_MONITOR)
|
|
INST_ID (GV$TEMP_SPACE_HEADER)
|
|
INST_ID (GV$LOCK_ELEMENT)
|
|
INST_ID (V$DLM_CONVERT_LOCAL)
|
|
INST_ID (X$KCBFWAIT)
|
|
INST_ID (GV$TEMP_CACHE_TRANSFER)
|
|
INST_ID (GV$MAP_FILE)
|
|
INST_ID (GV$GLOBAL_BLOCKED_LOCKS)
|
|
INST_ID (GV$LOADPSTAT)
|
|
INST_ID (GV$LOGMNR_LOGFILE)
|
|
INST_ID (GV$SGA_DYNAMIC_FREE_MEMORY)
|
|
INST_ID (GV$SQL_BIND_DATA)
|
|
INST_ID (GV$OBJECT_DEPENDENCY)
|
|
INST_ID (GV$MTTR_TARGET_ADVICE)
|
|
INST_ID (GV$LIBRARY_CACHE_MEMORY)
|
|
INST_ID (GV$GC_ELEMENT)
|
|
INST_ID (GV$OPTION)
|
|
INST_ID (GV$RMAN_CONFIGURATION)
|
|
INST_ID (GV$RSRC_CONSUMER_GROUP_CPU_MTH)
|
|
INST_ID (GV$SHARED_POOL_RESERVED)
|
|
INST_ID (GV$MAX_ACTIVE_SESS_TARGET_MTH)
|
|
INST_ID (GV$LOGSTDBY)
|
|
INST_ID (GV$LOCK)
|
|
INST_ID (GV$QUEUEING_MTH)
|
|
INST_ID (GV$RECOVER_FILE)
|
|
INST_ID (GV$RECOVERY_LOG)
|
|
INST_ID (GV$AW_CALC)
|
|
INST_ID (GV$DELETED_OBJECT)
|
|
INST_ID (GV$LOGMNR_LOGS)
|
|
INST_ID (GV$RESERVED_WORDS)
|
|
INST_ID (GV$VPD_POLICY)
|
|
INST_ID (GV$TABLESPACE)
|
|
INST_ID (GV$STATNAME)
|
|
INST_ID (GV$FILE_PING)
|
|
INST_ID (GV$CONTROLFILE_RECORD_SECTION)
|
|
INST_ID (GV$DATABASE_BLOCK_CORRUPTION)
|
|
INST_ID (GV$COPY_CORRUPTION)
|
|
INST_ID (GV$GES_BLOCKING_ENQUEUE)
|
|
INST_ID (GV$QUEUE)
|
|
INST_ID (GV$SQL_SHARED_MEMORY)
|
|
INST_ID (GV$MTS)
|
|
INST_ID (GV$PROCESS)
|
|
INST_ID (GV$LOGSTDBY_STATS)
|
|
INST_ID (GV$MAP_ELEMENT)
|
|
INST_ID (GV$SQLTEXT_WITH_NEWLINES)
|
|
INST_ID (GV$SQL_PLAN_STATISTICS)
|
|
INST_ID (GV$ACTIVE_INSTANCES)
|
|
INST_ID (GV$ARCHIVE_GAP)
|
|
INST_ID (GV$DATAGUARD_STATUS)
|
|
INST_ID (GV$TEMP_PING)
|
|
INST_ID (GV$LATCHHOLDER)
|
|
INST_ID (GV$BUFFER_POOL)
|
|
INST_ID (GV$BACKUP_REDOLOG)
|
|
INST_ID (GV$PGASTAT)
|
|
INST_ID (GV$GC_ELEMENTS_WITH_COLLISIONS)
|
|
INST_ID (GV$FILE_CACHE_TRANSFER)
|
|
INST_ID (GV$LATCH_PARENT)
|
|
INST_ID (GV$REQDIST)
|
|
INST_ID (GV$SQL)
|
|
INST_ID (GV$SGA_RESIZE_OPS)
|
|
INST_ID (GV$SESSION_OBJECT_CACHE)
|
|
INST_ID (GV$PROXY_DATAFILE)
|
|
INST_ID (GV$DLM_MISC)
|
|
INST_ID (GV$SUBCACHE)
|
|
INST_ID (GV$BACKUP_DEVICE)
|
|
INST_ID (GV$BSP)
|
|
INST_ID (V$DLM_CONVERT_REMOTE)
|
|
INST_ID (GV$GCSHVMASTER_INFO)
|
|
INST_ID (GV$PQ_SYSSTAT)
|
|
INST_ID (GV$SQL_CURSOR)
|
|
INST_ID (GV$RECOVERY_FILE_STATUS)
|
|
INST_ID (GV$LOGMNR_PROCESS)
|
|
INST_ID (GV$SGA_DYNAMIC_COMPONENTS)
|
|
INST_ID (GV$SYSTEM_EVENT)
|
|
INST_ID (GV$STREAMS_APPLY_READER)
|
|
INST_ID (GV$DBLINK)
|
|
INST_ID (GV$SQL_REDIRECTION)
|
|
INST_ID (GV$LATCH_CHILDREN)
|
|
INST_ID (GV$GCSPFMASTER_INFO)
|
|
INST_ID (GV$HS_PARAMETER)
|
|
INST_ID (GV$OFFLINE_RANGE)
|
|
INST_ID (GV$PQ_SLAVE)
|
|
INST_ID (GV$EXECUTION)
|
|
INST_ID (GV$RECOVERY_STATUS)
|
|
INST_ID (GV$LOGMNR_PARAMETERS)
|
|
INST_ID (GV$TEMPORARY_LOBS)
|
|
INST_ID (GV$ENABLEDPRIVS)
|
|
INST_ID (X$KSLLT)
|
|
INST_ID (GV$TEMPSTAT)
|
|
INST_ID (GV$BACKUP_DATAFILE)
|
|
INST_ID (GV$LOGFILE)
|
|
INST_ID (GV$STREAMS_APPLY_SERVER)
|
|
INST_ID (GV$SESSION_WAIT)
|
|
INST_LOCK_ID1 (GV$ROWCACHE_PARENT)
|
|
INST_LOCK_ID1 (V$ROWCACHE_PARENT)
|
|
INST_LOCK_ID2 (V$ROWCACHE_PARENT)
|
|
INST_LOCK_ID2 (GV$ROWCACHE_PARENT)
|
|
INTERNAL_COLUMN_ID (DBA_TAB_COLS)
| Internal sequence number of the column
|
INTERNAL_COLUMN_ID (USER_TAB_COLS)
| Internal sequence number of the column
|
INTERNAL_COLUMN_ID (ALL_TAB_COLS)
| Internal sequence number of the column
|
JOIN_KEY_ID (ALL_DIM_CHILD_OF)
| Keys that join child uniquely to the parent
|
JOIN_KEY_ID (DBA_DIM_CHILD_OF)
| Keys that join child uniquely to the parent
|
JOIN_KEY_ID (USER_DIM_CHILD_OF)
| Keys that join child uniquely to the parent
|
LOCAL_TRANSACTION_ID (ALL_APPLY_ERROR)
| Local transaction ID for the error creation transaction
|
LOCAL_TRANSACTION_ID (DBA_APPLY_ERROR)
| Local transaction ID for the error creation transaction
|
LOCAL_TRAN_ID (DBA_2PC_PENDING)
| string of form: n.n.n, n a number
|
LOCAL_TRAN_ID (DBA_2PC_NEIGHBORS)
|
|
LOCK_ID1 (DBA_LOCK_INTERNAL)
|
|
LOCK_ID1 (DBA_WAITERS)
|
|
LOCK_ID1 (DBA_LOCK)
|
|
LOCK_ID1 (DBA_LOCKS)
|
|
LOCK_ID2 (DBA_LOCK)
|
|
LOCK_ID2 (DBA_LOCK_INTERNAL)
|
|
LOCK_ID2 (DBA_LOCKS)
|
|
LOCK_ID2 (DBA_WAITERS)
|
|
LOGMINER_ID (DBA_CAPTURE)
| Session ID of LogMiner session associated with the capture process
|
LOGSTDBY_ID (V$LOGSTDBY)
|
|
LOGSTDBY_ID (GV$LOGSTDBY)
|
|
LOG_ID (GV$LOGMNR_LOGS)
|
|
LOG_ID (V$LOGMNR_LOGFILE)
|
|
LOG_ID (V$LOGMNR_CONTENTS)
|
|
LOG_ID (GV$LOGMNR_CONTENTS)
|
|
LOG_ID (V$LOGMNR_LOGS)
|
|
LOG_ID (ALL_REPDDL)
| Identifying number of the repcat log record
|
LOG_ID (USER_REPDDL)
| Identifying number of the repcat log record
|
LOG_ID (GV$LOGMNR_LOGFILE)
|
|
LOG_ID (DBA_REPDDL)
| Identifying number of the repcat log record
|
MVIEW_ID (DBA_BASE_TABLE_MVIEWS)
| Unique identifier of the materialized view
|
MVIEW_ID (USER_REGISTERED_MVIEWS)
| Identifier for the materialized view used by the master for fast refresh
|
MVIEW_ID (DBA_REGISTERED_MVIEWS)
| Identifier for the materialized view used by the master for fast refresh
|
MVIEW_ID (USER_BASE_TABLE_MVIEWS)
| Unique identifier of the materialized view
|
MVIEW_ID (ALL_REGISTERED_MVIEWS)
| Identifier for the materialized view used by the master for fast refresh
|
MVIEW_ID (ALL_BASE_TABLE_MVIEWS)
| Unique identifier of the materialized view
|
OBJECT_ID (USER_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (USER_OBJECTS)
| Object number of the object
|
OBJECT_ID (V$FIXED_TABLE)
|
|
OBJECT_ID (ALL_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (GV$LOCKED_OBJECT)
|
|
OBJECT_ID (GV$FIXED_TABLE)
|
|
OBJECT_ID (ALL_ARGUMENTS)
| Object number of the object
|
OBJECT_ID (USER_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (DBA_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (ALL_OBJECTS)
| Object number of the object
|
OBJECT_ID (DBA_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (DBA_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (ALL_PROBE_OBJECTS)
|
|
OBJECT_ID (V$LOCKED_OBJECT)
|
|
OBJECT_ID (DBA_OBJECTS)
| Object number of the object
|
OBJECT_ID (USER_SNAPSHOT_LOGS)
| If YES, the snapshot log records object id information
|
OBJECT_ID (ALL_STORED_SETTINGS)
| Object number of the object
|
OBJECT_ID (USER_ARGUMENTS)
| Object number of the object
|
OBJECT_ID (ALL_MVIEW_LOGS)
| If YES, the materialized view log records object id information
|
OBJECT_ID (OBJ)
| Object number of the object
|
OBJECT_ID_TYPE (ALL_ALL_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 (USER_ALL_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYST EM 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 (DBA_OBJECT_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 (DBA_REFS)
| If ref contains user-defined OID, then USER-DEFINED, else if it contains 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_ALL_TABLES)
| If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
|
OBJECT_TYPE_ID (DBA_IAS_OBJECTS_BASE)
|
|
OPERATION_ID (V$SQL_WORKAREA_ACTIVE)
|
|
OPERATION_ID (GV$SQL_PLAN_STATISTICS)
|
|
OPERATION_ID (V$SQL_PLAN_STATISTICS)
|
|
OPERATION_ID (GV$SQL_WORKAREA_ACTIVE)
|
|
OPERATION_ID (V$SQL_WORKAREA)
|
|
OPERATION_ID (GV$SQL_WORKAREA)
|
|
OWNER_ID (V$DBLINK)
|
|
OWNER_ID (GV$DBLINK)
|
|
PARENT_ID (DBA_REGISTRY)
|
|
PARENT_ID (GV$MAP_FILE_IO_STACK)
|
|
PARENT_ID (V$MAP_FILE_IO_STACK)
|
|
PARENT_ID (V$SQL_PLAN_STATISTICS_ALL)
|
|
PARENT_ID (USER_REGISTRY)
|
|
PARENT_ID (V$SQL_PLAN)
|
|
PARENT_ID (GV$SQL_PLAN)
|
|
PARENT_ID (GV$SQL_PLAN_STATISTICS_ALL)
|
|
PARSING_SCHEMA_ID (GV$SQLAREA)
|
|
PARSING_SCHEMA_ID (GV$SQL)
|
|
PARSING_SCHEMA_ID (V$SQL)
|
|
PARSING_SCHEMA_ID (V$SQLAREA)
|
|
PARSING_SCHEMA_ID (GV$SQL_REDIRECTION)
|
|
PARSING_SCHEMA_ID (V$SQL_REDIRECTION)
|
|
PARSING_USER_ID (GV$SQL_REDIRECTION)
|
|
PARSING_USER_ID (GV$SQLAREA)
|
|
PARSING_USER_ID (V$SQL_REDIRECTION)
|
|
PARSING_USER_ID (V$SQL)
|
|
PARSING_USER_ID (V$SQLAREA)
|
|
PARSING_USER_ID (GV$SQL)
|
|
PARTITION_ID (V$SQL_PLAN)
|
|
PARTITION_ID (GV$SQL_PLAN)
|
|
PARTITION_ID (GV$SQL_PLAN_STATISTICS_ALL)
|
|
PARTITION_ID (V$SQL_PLAN_STATISTICS_ALL)
|
|
PUB_ID (ALL_PUBLISHED_COLUMNS)
|
|
PUB_ID (DBA_PUBLISHED_COLUMNS)
|
|
QCINST_ID (GV$PX_SESSION)
|
|
QCINST_ID (V$SQL_WORKAREA_ACTIVE)
|
|
QCINST_ID (GV$SQL_WORKAREA_ACTIVE)
|
|
QCINST_ID (V$PX_SESSTAT)
|
|
QCINST_ID (GV$PX_SESSTAT)
|
|
QCINST_ID (V$PX_SESSION)
|
|
RECIPIENT_ID (ALL_APPLY_ERROR)
| User ID of the original recipient
|
RECIPIENT_ID (DBA_APPLY_ERROR)
| User ID of the original recipient
|
REFRESH_GROUP_ID (DBA_TEMPLATE_REFGROUPS)
| Internal primary key of the refresh groups table.
|
REFRESH_TEMPLATE_ID (DBA_TEMPLATE_REFGROUPS)
| Primary key of the template containing the refresh group.
|
REPCATLOG_ID (DBA_REPEXTENSIONS)
| Identifier of repcatlog records related to replication extension
|
ROW_ID (V$LOGMNR_CONTENTS)
|
|
ROW_ID (GV$LOGMNR_CONTENTS)
|
|
RS_ID (V$LOGMNR_CONTENTS)
|
|
RS_ID (GV$LOGMNR_CONTENTS)
|
|
SEGMENT_COLUMN_ID (DBA_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_COLUMN_ID (ALL_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_COLUMN_ID (USER_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_ID (DBA_ROLLBACK_SEGS)
| ID number of the rollback segment
|
SERVER_ID (GV$STREAMS_APPLY_SERVER)
|
|
SERVER_ID (V$STREAMS_APPLY_SERVER)
|
|
SESSION_ID (V$AW_OLAP)
|
|
SESSION_ID (V$LOGMNR_SESSION)
|
|
SESSION_ID (DBA_LOCK_INTERNAL)
|
|
SESSION_ID (DBA_LOCKS)
|
|
SESSION_ID (GV$AW_OLAP)
|
|
SESSION_ID (USER_QUEUE_SCHEDULES)
|
|
SESSION_ID (GV$LOCKED_OBJECT)
|
|
SESSION_ID (DBA_LOCK)
|
|
SESSION_ID (DBA_DDL_LOCKS)
|
|
SESSION_ID (V$LOGMNR_STATS)
|
|
SESSION_ID (DBA_RESUMABLE)
| Session ID of this resumable session
|
SESSION_ID (DBA_FGA_AUDIT_TRAIL)
| Session id of the query
|
SESSION_ID (DBA_QUEUE_SCHEDULES)
|
|
SESSION_ID (DBA_DML_LOCKS)
|
|
SESSION_ID (GV$LOGMNR_STATS)
|
|
SESSION_ID (GV$LOGMNR_SESSION)
|
|
SESSION_ID (USER_RESUMABLE)
| Session ID of this resumable session
|
SESSION_ID (V$LOCKED_OBJECT)
|
|
SNAPSHOT_ID (USER_REGISTERED_SNAPSHOTS)
| Identifier for the snapshot used by the master for fast refresh
|
SNAPSHOT_ID (ALL_SNAPSHOT_LOGS)
| Unique identifier of the snapshot
|
SNAPSHOT_ID (USER_SNAPSHOT_LOGS)
|
|
SNAPSHOT_ID (DBA_REGISTERED_SNAPSHOTS)
| Identifier for the snapshot used by the master for fast refresh
|
SNAPSHOT_ID (ALL_REGISTERED_SNAPSHOTS)
| Identifier for the snapshot used by the master for fast refresh
|
SNAPSHOT_ID (DBA_SNAPSHOT_LOGS)
| Unique identifier of the snapshot
|
SOURCE_TRANSACTION_ID (ALL_APPLY_ERROR)
| Original transaction ID at the source database
|
SOURCE_TRANSACTION_ID (DBA_APPLY_ERROR)
| Original transaction ID at the source database
|
TABLESPACE_ID (DBA_DMT_USED_EXTENTS)
| ID of the tablespace containing the extent
|
TABLESPACE_ID (DBA_DMT_FREE_SPACE)
| ID of the tablespace containing the extent
|
TABLESPACE_ID (DBA_LMT_FREE_SPACE)
| ID of the tablespace containing the extent
|
TABLESPACE_ID (DBA_LMT_USED_EXTENTS)
| ID of the tablespace containing the extent
|
TEMPLATE_ID (DBA_IAS_OBJECTS_EXP)
|
|
TEMPLATE_TARGET_ID (DBA_TEMPLATE_TARGETS)
| Internal primary key of the template targets table.
|
THREAD_ID (GV$LOGMNR_LOGS)
|
|
THREAD_ID (V$LOGMNR_LOGFILE)
|
|
THREAD_ID (V$LOGMNR_LOGS)
|
|
THREAD_ID (GV$LOGMNR_LOGFILE)
|
|
TQ_ID (GV$PQ_TQSTAT)
|
|
TQ_ID (V$PQ_TQSTAT)
|
|
TRANSACTION_ID0 (V$DLM_LOCKS)
|
|
TRANSACTION_ID0 (V$GES_ENQUEUE)
|
|
TRANSACTION_ID0 (GV$DLM_LOCKS)
|
|
TRANSACTION_ID0 (GV$GES_ENQUEUE)
|
|
TRANSACTION_ID0 (V$DLM_ALL_LOCKS)
|
|
TRANSACTION_ID0 (GV$DLM_ALL_LOCKS)
|
|
TRANSACTION_ID0 (GV$GES_BLOCKING_ENQUEUE)
|
|
TRANSACTION_ID0 (V$GES_BLOCKING_ENQUEUE)
|
|
TRANSACTION_ID1 (GV$DLM_ALL_LOCKS)
|
|
TRANSACTION_ID1 (V$GES_BLOCKING_ENQUEUE)
|
|
TRANSACTION_ID1 (GV$GES_ENQUEUE)
|
|
TRANSACTION_ID1 (GV$DLM_LOCKS)
|
|
TRANSACTION_ID1 (V$DLM_ALL_LOCKS)
|
|
TRANSACTION_ID1 (GV$GES_BLOCKING_ENQUEUE)
|
|
TRANSACTION_ID1 (V$DLM_LOCKS)
|
|
TRANSACTION_ID1 (V$GES_ENQUEUE)
|
|
TRANSFORMATION_ID (USER_ATTRIBUTE_TRANSFORMATIONS)
|
|
TRANSFORMATION_ID (USER_TRANSFORMATIONS)
|
|
TRANSFORMATION_ID (DBA_TRANSFORMATIONS)
|
|
TRANSFORMATION_ID (DBA_ATTRIBUTE_TRANSFORMATIONS)
|
|
TYPE_ID (GV$COMPATSEG)
|
|
TYPE_ID (V$COMPATIBILITY)
|
|
TYPE_ID (V$COMPATSEG)
|
|
TYPE_ID (GV$COMPATIBILITY)
|
|
USER_ID (USER_USERS)
| ID number of the user
|
USER_ID (DBA_USERS)
| ID number of the user
|
USER_ID (DBA_RESUMABLE)
| User who own this resumable session
|
USER_ID (ALL_USERS)
| ID number of the user
|