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_CONS_GROUP_HISTORY

Object Details

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

[View Source]

Columns

Name	Datatype	Length
SEQUENCE#	NUMBER
ID	NUMBER
NAME	VARCHAR2	(30)
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
ACTIVE_SESS_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_SESS_KILLED	NUMBER
IDLE_SESS_KILLED	NUMBER
IDLE_BLKR_SESS_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
PQS_COMPLETED	NUMBER
PQ_SERVERS_USED	NUMBER
PQS_QUEUED	NUMBER
PQ_ACTIVE_TIME	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 SEQUENCE#
,      ID
,      NAME
,      REQUESTS
,      CPU_WAIT_TIME
,      CPU_WAITS
,      CONSUMED_CPU_TIME
,      YIELDS
,      CPU_DECISIONS
,      CPU_DECISIONS_EXCLUSIVE
,      CPU_DECISIONS_WON
,      ACTIVE_SESS_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_SESS_KILLED
,      IDLE_SESS_KILLED
,      IDLE_BLKR_SESS_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
,      PQS_COMPLETED
,      PQ_SERVERS_USED
,      PQS_QUEUED
,      PQ_ACTIVE_TIME
,      PQ_QUEUED_TIME
,      PQ_QUEUE_TIME_OUTS
,      CON_ID
FROM SYS.V_$RSRC_CONS_GROUP_HISTORY;

Dependencies

[top of page]

SYS.V_$RSRC_CONS_GROUP_HISTORY references the following:

SYS.V_$RSRC_CONS_GROUP_HISTORY is referenced by following:

PUBLIC: V$RSRC_CONS_GROUP_HISTORY