[Home] [Help] [Dependency Information]
Object Name: | GV_$RSRC_SESSION_INFO |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SID | NUMBER | |||
CURRENT_CONSUMER_GROUP_ID | NUMBER | |||
CURRENT_CONSUMER_GROUP | VARCHAR2 | (32) | ||
ORIG_CONSUMER_GROUP_ID | NUMBER | |||
MAPPING_ATTRIBUTE | VARCHAR2 | (32) | ||
MAPPED_CONSUMER_GROUP | VARCHAR2 | (32) | ||
STATE | VARCHAR2 | (32) | ||
ACTIVE | VARCHAR2 | (5) | ||
CURRENT_IDLE_TIME | NUMBER | |||
CURRENT_CPU_WAIT_TIME | NUMBER | |||
CPU_WAIT_TIME | NUMBER | |||
CURRENT_CPU_WAITS | NUMBER | |||
CPU_WAITS | NUMBER | |||
CURRENT_CONSUMED_CPU_TIME | NUMBER | |||
CONSUMED_CPU_TIME | NUMBER | |||
CURRENT_ACTIVE_TIME | NUMBER | |||
ACTIVE_TIME | NUMBER | |||
CURRENT_QUEUED_TIME | NUMBER | |||
QUEUED_TIME | NUMBER | |||
CURRENT_YIELDS | NUMBER | |||
YIELDS | NUMBER | |||
CURRENT_UNDO_CONSUMPTION | NUMBER | |||
MAX_UNDO_CONSUMPTION | NUMBER | |||
SQL_CANCELED | NUMBER | |||
QUEUE_TIME_OUTS | NUMBER | |||
ESTIMATED_EXECUTION_LIMIT_HIT | NUMBER | |||
CURRENT_IO_SERVICE_TIME | NUMBER | |||
IO_SERVICE_TIME | NUMBER | |||
CURRENT_IO_SERVICE_WAITS | NUMBER | |||
IO_SERVICE_WAITS | NUMBER | |||
CURRENT_SMALL_READ_MEGABYTES | NUMBER | |||
SMALL_READ_MEGABYTES | NUMBER | |||
CURRENT_LARGE_READ_MEGABYTES | NUMBER | |||
LARGE_READ_MEGABYTES | NUMBER | |||
CURRENT_SMALL_WRITE_MEGABYTES | NUMBER | |||
SMALL_WRITE_MEGABYTES | NUMBER | |||
CURRENT_LARGE_WRITE_MEGABYTES | NUMBER | |||
LARGE_WRITE_MEGABYTES | NUMBER | |||
CURRENT_SMALL_READ_REQUESTS | NUMBER | |||
SMALL_READ_REQUESTS | NUMBER | |||
CURRENT_SMALL_WRITE_REQUESTS | NUMBER | |||
SMALL_WRITE_REQUESTS | NUMBER | |||
CURRENT_LARGE_READ_REQUESTS | NUMBER | |||
LARGE_READ_REQUESTS | NUMBER | |||
CURRENT_LARGE_WRITE_REQUESTS | NUMBER | |||
LARGE_WRITE_REQUESTS | NUMBER | |||
CURRENT_PQ_ACTIVE_TIME | NUMBER | |||
PQ_ACTIVE_TIME | NUMBER | |||
DOP | NUMBER | |||
PQ_SERVERS | NUMBER | |||
ESTIMATED_EXECUTION_TIME | NUMBER | |||
CURRENT_PQ_QUEUED_TIME | NUMBER | |||
PQ_QUEUED_TIME | NUMBER | |||
PQ_QUEUED | NUMBER | |||
PQ_QUEUE_TIME_OUTS | NUMBER | |||
PQ_ACTIVE | VARCHAR2 | (5) | ||
PQ_STATUS | VARCHAR2 | (44) | ||
CURRENT_LOGICAL_IOS | NUMBER | |||
LOGICAL_IOS | NUMBER | |||
CURRENT_ELAPSED_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
LAST_ACTION | VARCHAR2 | (48) | ||
LAST_ACTION_REASON | VARCHAR2 | (30) | ||
LAST_ACTION_TIME | DATE | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, SID
, CURRENT_CONSUMER_GROUP_ID
, CURRENT_CONSUMER_GROUP
, ORIG_CONSUMER_GROUP_ID
, MAPPING_ATTRIBUTE
, MAPPED_CONSUMER_GROUP
, STATE
, ACTIVE
, CURRENT_IDLE_TIME
, CURRENT_CPU_WAIT_TIME
, CPU_WAIT_TIME
, CURRENT_CPU_WAITS
, CPU_WAITS
, CURRENT_CONSUMED_CPU_TIME
, CONSUMED_CPU_TIME
, CURRENT_ACTIVE_TIME
, ACTIVE_TIME
, CURRENT_QUEUED_TIME
, QUEUED_TIME
, CURRENT_YIELDS
, YIELDS
, CURRENT_UNDO_CONSUMPTION
, MAX_UNDO_CONSUMPTION
, SQL_CANCELED
, QUEUE_TIME_OUTS
, ESTIMATED_EXECUTION_LIMIT_HIT
, CURRENT_IO_SERVICE_TIME
, IO_SERVICE_TIME
, CURRENT_IO_SERVICE_WAITS
, IO_SERVICE_WAITS
, CURRENT_SMALL_READ_MEGABYTES
, SMALL_READ_MEGABYTES
, CURRENT_LARGE_READ_MEGABYTES
, LARGE_READ_MEGABYTES
, CURRENT_SMALL_WRITE_MEGABYTES
, SMALL_WRITE_MEGABYTES
, CURRENT_LARGE_WRITE_MEGABYTES
, LARGE_WRITE_MEGABYTES
, CURRENT_SMALL_READ_REQUESTS
, SMALL_READ_REQUESTS
, CURRENT_SMALL_WRITE_REQUESTS
, SMALL_WRITE_REQUESTS
, CURRENT_LARGE_READ_REQUESTS
, LARGE_READ_REQUESTS
, CURRENT_LARGE_WRITE_REQUESTS
, LARGE_WRITE_REQUESTS
, CURRENT_PQ_ACTIVE_TIME
, PQ_ACTIVE_TIME
, DOP
, PQ_SERVERS
, ESTIMATED_EXECUTION_TIME
, CURRENT_PQ_QUEUED_TIME
, PQ_QUEUED_TIME
, PQ_QUEUED
, PQ_QUEUE_TIME_OUTS
, PQ_ACTIVE
, PQ_STATUS
, CURRENT_LOGICAL_IOS
, LOGICAL_IOS
, CURRENT_ELAPSED_TIME
, ELAPSED_TIME
, LAST_ACTION
, LAST_ACTION_REASON
, LAST_ACTION_TIME
, CON_ID
FROM SYS.GV_$RSRC_SESSION_INFO;
|
|
|