[Home] [Help] [Dependency Information]
Object Name: | V_$RSRC_CONSUMER_GROUP |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|