DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$RSRC_SESSION_INFO

Object Details
Object Name: V_$RSRC_SESSION_INFO
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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.V_$RSRC_SESSION_INFO;

Dependencies

[top of page]

SYS.V_$RSRC_SESSION_INFO references the following:

SYS.V_$RSRC_SESSION_INFO is referenced by following:

SchemaPUBLIC
SynonymV$RSRC_SESSION_INFO