DBA Data[Home] [Help]

VIEW: SYS.GV_$RSRC_SESSION_INFO

Source

View Text - Preformatted

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 gv$rsrc_session_info
View Text - HTML Formatted

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 GV$RSRC_SESSION_INFO