home - keyword index

Keyword: INSTANCE

jump to Columns back to index

Tables

Table Name Description
GV$ACTIVE_INSTANCES Synonym for GV_$ACTIVE_INSTANCES
GV$INSTANCE Synonym for GV_$INSTANCE
GV$INSTANCE_RECOVERY Synonym for GV_$INSTANCE_RECOVERY
NLS_INSTANCE_PARAMETERS NLS parameters of the instance
V$ACTIVE_INSTANCES Synonym for V_$ACTIVE_INSTANCES
V$INSTANCE Synonym for V_$INSTANCE
V$INSTANCE_RECOVERY Synonym for V_$INSTANCE_RECOVERY
top back to index

Columns

Column Name Description
COORD_INSTANCE_ID (USER_RESUMABLE) Instance number of parallel query coordinator
COORD_INSTANCE_ID (DBA_RESUMABLE) Instance number of parallel query coordinator
INSTANCE (GV$PQ_TQSTAT)
INSTANCE (DBA_JOBS_RUNNING) The instance number restricted to run the job
INSTANCE (DBA_JOBS) Instance number restricted to run the job
INSTANCE (DBA_QUEUE_SCHEDULES)
INSTANCE (USER_QUEUE_SCHEDULES)
INSTANCE (USER_JOBS) Instance number restricted to run the job
INSTANCE (GV$THREAD)
INSTANCE (V$THREAD)
INSTANCE (V$PQ_TQSTAT)
INSTANCE (ALL_JOBS) Instance number restricted to run the job
INSTANCES (USER_CLUSTERS) The number of instances across which the cluster is to be scanned
INSTANCES (DBA_TABLES) The number of instances across which the table is to be scanned
INSTANCES (TABS) The number of instances across which the table is to be scanned
INSTANCES (USER_OBJECT_TABLES) The number of instances across which the table is to be scanned
INSTANCES (ALL_CLUSTERS) The number of instances across which the cluster is to be scanned
INSTANCES (ALL_ALL_TABLES) The number of instances across which the table is to be scanned
INSTANCES (IND) The number of instances across which the partitioned index is to be scanned
INSTANCES (USER_ALL_TABLES) The number of instances across which the table is to be scanned
INSTANCES (USER_TABLES) The number of instances across which the table is to be scanned
INSTANCES (USER_INDEXES) The number of instances across which the partitioned index is to be scanned
INSTANCES (DBA_OBJECT_TABLES) The number of instances across which the table is to be scanned
INSTANCES (CLU) The number of instances across which the cluster is to be scanned
INSTANCES (ALL_INDEXES) The number of instances across which the partitioned index is to be scanned
INSTANCES (DBA_CLUSTERS) The number of instances across which the cluster is to be scanned
INSTANCES (ALL_OBJECT_TABLES) The number of instances across which the table is to be scanned
INSTANCES (DBA_INDEXES) The number of instances across which the partitioned index is to be scanned
INSTANCES (DBA_ALL_TABLES) The number of instances across which the table is to be scanned
INSTANCES (ALL_TABLES) The number of instances across which the table is to be scanned
INSTANCE_ID (DBA_RESUMABLE) Instance ID of this resumable session
INSTANCE_ID (USER_RESUMABLE) Instance ID of this resumable session
INSTANCE_NAME (GV$INSTANCE)
INSTANCE_NAME (V$INSTANCE)
INSTANCE_NUM (DBA_ROLLBACK_SEGS) Rollback segment owning parallel server instance number
INSTANCE_NUMBER (V$INSTANCE)
INSTANCE_NUMBER (GV$INSTANCE)
INSTANCE_ROLE (GV$INSTANCE)
INSTANCE_ROLE (V$INSTANCE)
OWNER_INSTANCE (DBA_QUEUE_TABLES) Instance which owns the queue table currently
OWNER_INSTANCE (ALL_QUEUE_TABLES) Instance which owns the queue table currently
OWNER_INSTANCE (USER_QUEUE_TABLES) Instance which owns the queue table currently
PRIMARY_INSTANCE (DBA_QUEUE_TABLES) Instance assigned as the primary owner of the queue table
PRIMARY_INSTANCE (ALL_QUEUE_TABLES) Instance assigned as the primary owner of the queue table
PRIMARY_INSTANCE (USER_QUEUE_TABLES) Instance assigned as the primary owner of the queue table
SECONDARY_INSTANCE (USER_QUEUE_TABLES) Instance assigned as the secondary owner of the queue table
SECONDARY_INSTANCE (ALL_QUEUE_TABLES) Instance assigned as the secondary owner of the queue table
SECONDARY_INSTANCE (DBA_QUEUE_TABLES) Instance assigned as the secondary owner of the queue table
top back to index

Comment on this page:




home - keyword index