eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.V_$RSRC_CONSUMER_GROUP

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ID	NUMBER
NAME	VARCHAR2	(32)
ACTIVE_SESSIONS	NUMBER
EXECUTION_WAITERS	NUMBER
REQUESTS	NUMBER
CPU_WAIT_TIME	NUMBER
CPU_WAITS	NUMBER
CONSUMED_CPU_TIME	NUMBER
YIELDS	NUMBER
CPU_DECISIONS	NUMBER
CPU_DECISIONS_EXCLUSIVE	NUMBER
CPU_DECISIONS_WON	NUMBER
QUEUE_LENGTH	NUMBER
CURRENT_UNDO_CONSUMPTION	NUMBER
ACTIVE_SESSION_LIMIT_HIT	NUMBER
UNDO_LIMIT_HIT	NUMBER
SWITCHES_IN_CPU_TIME	NUMBER
SWITCHES_OUT_CPU_TIME	NUMBER
SWITCHES_IN_IO_MEGABYTES	NUMBER
SWITCHES_OUT_IO_MEGABYTES	NUMBER
SWITCHES_IN_IO_REQUESTS	NUMBER
SWITCHES_OUT_IO_REQUESTS	NUMBER
SWITCHES_IN_IO_LOGICAL	NUMBER
SWITCHES_OUT_IO_LOGICAL	NUMBER
SWITCHES_IN_ELAPSED_TIME	NUMBER
SWITCHES_OUT_ELAPSED_TIME	NUMBER
SQL_CANCELED	NUMBER
ACTIVE_SESSIONS_KILLED	NUMBER
IDLE_SESSIONS_KILLED	NUMBER
IDLE_BLKR_SESSIONS_KILLED	NUMBER
QUEUED_TIME	NUMBER
QUEUE_TIME_OUTS	NUMBER
IO_SERVICE_TIME	NUMBER
IO_SERVICE_WAITS	NUMBER
SMALL_READ_MEGABYTES	NUMBER
SMALL_WRITE_MEGABYTES	NUMBER
LARGE_READ_MEGABYTES	NUMBER
LARGE_WRITE_MEGABYTES	NUMBER
SMALL_READ_REQUESTS	NUMBER
SMALL_WRITE_REQUESTS	NUMBER
LARGE_READ_REQUESTS	NUMBER
LARGE_WRITE_REQUESTS	NUMBER
CURRENT_PQS_ACTIVE	NUMBER
CURRENT_PQ_SERVERS_ACTIVE	NUMBER
PQS_QUEUED	NUMBER
PQS_COMPLETED	NUMBER
PQ_SERVERS_USED	NUMBER
PQ_ACTIVE_TIME	NUMBER
CURRENT_PQS_QUEUED	NUMBER
PQ_QUEUED_TIME	NUMBER
PQ_QUEUE_TIME_OUTS	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT ID
,      NAME
,      ACTIVE_SESSIONS
,      EXECUTION_WAITERS
,      REQUESTS
,      CPU_WAIT_TIME
,      CPU_WAITS
,      CONSUMED_CPU_TIME
,      YIELDS
,      CPU_DECISIONS
,      CPU_DECISIONS_EXCLUSIVE
,      CPU_DECISIONS_WON
,      QUEUE_LENGTH
,      CURRENT_UNDO_CONSUMPTION
,      ACTIVE_SESSION_LIMIT_HIT
,      UNDO_LIMIT_HIT
,      SWITCHES_IN_CPU_TIME
,      SWITCHES_OUT_CPU_TIME
,      SWITCHES_IN_IO_MEGABYTES
,      SWITCHES_OUT_IO_MEGABYTES
,      SWITCHES_IN_IO_REQUESTS
,      SWITCHES_OUT_IO_REQUESTS
,      SWITCHES_IN_IO_LOGICAL
,      SWITCHES_OUT_IO_LOGICAL
,      SWITCHES_IN_ELAPSED_TIME
,      SWITCHES_OUT_ELAPSED_TIME
,      SQL_CANCELED
,      ACTIVE_SESSIONS_KILLED
,      IDLE_SESSIONS_KILLED
,      IDLE_BLKR_SESSIONS_KILLED
,      QUEUED_TIME
,      QUEUE_TIME_OUTS
,      IO_SERVICE_TIME
,      IO_SERVICE_WAITS
,      SMALL_READ_MEGABYTES
,      SMALL_WRITE_MEGABYTES
,      LARGE_READ_MEGABYTES
,      LARGE_WRITE_MEGABYTES
,      SMALL_READ_REQUESTS
,      SMALL_WRITE_REQUESTS
,      LARGE_READ_REQUESTS
,      LARGE_WRITE_REQUESTS
,      CURRENT_PQS_ACTIVE
,      CURRENT_PQ_SERVERS_ACTIVE
,      PQS_QUEUED
,      PQS_COMPLETED
,      PQ_SERVERS_USED
,      PQ_ACTIVE_TIME
,      CURRENT_PQS_QUEUED
,      PQ_QUEUED_TIME
,      PQ_QUEUE_TIME_OUTS
,      CON_ID
FROM SYS.V_$RSRC_CONSUMER_GROUP;

Dependencies

[top of page]

SYS.V_$RSRC_CONSUMER_GROUP references the following:

SYS.V_$RSRC_CONSUMER_GROUP is referenced by following:

PUBLIC: V$RSRC_CONSUMER_GROUP