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.GV_$RSRCMGRMETRIC_HISTORY

Object Details

Object Name:	GV_$RSRCMGRMETRIC_HISTORY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
BEGIN_TIME	DATE
END_TIME	DATE
INTSIZE_CSEC	NUMBER
SEQUENCE#	NUMBER
CONSUMER_GROUP_ID	NUMBER
CONSUMER_GROUP_NAME	VARCHAR2	(30)
CPU_CONSUMED_TIME	NUMBER
CPU_WAIT_TIME	NUMBER
NUM_CPUS	NUMBER
RUNNING_SESSIONS_LIMIT	NUMBER
AVG_RUNNING_SESSIONS	NUMBER
AVG_WAITING_SESSIONS	NUMBER
CPU_UTILIZATION_LIMIT	NUMBER
AVG_CPU_UTILIZATION	NUMBER
CPU_DECISIONS	NUMBER
CPU_DECISIONS_EXCLUSIVE	NUMBER
CPU_DECISIONS_WON	NUMBER
IO_REQUESTS	NUMBER
IO_MEGABYTES	NUMBER
AVG_ACTIVE_PARALLEL_STMTS	NUMBER
AVG_QUEUED_PARALLEL_STMTS	NUMBER
AVG_ACTIVE_PARALLEL_SERVERS	NUMBER
AVG_QUEUED_PARALLEL_SERVERS	NUMBER
PARALLEL_SERVERS_LIMIT	NUMBER
PLAN_NAME	VARCHAR2	(30)
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      BEGIN_TIME
,      END_TIME
,      INTSIZE_CSEC
,      SEQUENCE#
,      CONSUMER_GROUP_ID
,      CONSUMER_GROUP_NAME
,      CPU_CONSUMED_TIME
,      CPU_WAIT_TIME
,      NUM_CPUS
,      RUNNING_SESSIONS_LIMIT
,      AVG_RUNNING_SESSIONS
,      AVG_WAITING_SESSIONS
,      CPU_UTILIZATION_LIMIT
,      AVG_CPU_UTILIZATION
,      CPU_DECISIONS
,      CPU_DECISIONS_EXCLUSIVE
,      CPU_DECISIONS_WON
,      IO_REQUESTS
,      IO_MEGABYTES
,      AVG_ACTIVE_PARALLEL_STMTS
,      AVG_QUEUED_PARALLEL_STMTS
,      AVG_ACTIVE_PARALLEL_SERVERS
,      AVG_QUEUED_PARALLEL_SERVERS
,      PARALLEL_SERVERS_LIMIT
,      PLAN_NAME
,      CON_ID
FROM SYS.GV_$RSRCMGRMETRIC_HISTORY;

Dependencies

[top of page]

SYS.GV_$RSRCMGRMETRIC_HISTORY references the following:

SYS.GV_$RSRCMGRMETRIC_HISTORY is referenced by following:

PUBLIC: GV$RSRCMGRMETRIC_HISTORY