[Home] [Help] [Dependency Information]
Object Name: | INT$DBA_HIST_RSRC_CON_GROUP |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
SEQUENCE# | NUMBER | Yes | ||
CONSUMER_GROUP_ID | NUMBER | Yes | ||
CONSUMER_GROUP_NAME | VARCHAR2 | (128) | Yes | |
REQUESTS | NUMBER | Yes | ||
CPU_WAIT_TIME | NUMBER | Yes | ||
CPU_WAITS | NUMBER | Yes | ||
CONSUMED_CPU_TIME | NUMBER | Yes | ||
YIELDS | NUMBER | Yes | ||
ACTIVE_SESS_LIMIT_HIT | NUMBER | Yes | ||
UNDO_LIMIT_HIT | NUMBER | Yes | ||
SWITCHES_IN_CPU_TIME | NUMBER | Yes | ||
SWITCHES_OUT_CPU_TIME | NUMBER | Yes | ||
SWITCHES_IN_IO_MEGABYTES | NUMBER | Yes | ||
SWITCHES_OUT_IO_MEGABYTES | NUMBER | Yes | ||
SWITCHES_IN_IO_REQUESTS | NUMBER | Yes | ||
SWITCHES_OUT_IO_REQUESTS | NUMBER | Yes | ||
SQL_CANCELED | NUMBER | Yes | ||
ACTIVE_SESS_KILLED | NUMBER | Yes | ||
IDLE_SESS_KILLED | NUMBER | Yes | ||
IDLE_BLKR_SESS_KILLED | NUMBER | Yes | ||
QUEUED_TIME | NUMBER | Yes | ||
QUEUE_TIME_OUTS | NUMBER | Yes | ||
IO_SERVICE_TIME | NUMBER | Yes | ||
IO_SERVICE_WAITS | NUMBER | Yes | ||
SMALL_READ_MEGABYTES | NUMBER | Yes | ||
SMALL_WRITE_MEGABYTES | NUMBER | Yes | ||
LARGE_READ_MEGABYTES | NUMBER | Yes | ||
LARGE_WRITE_MEGABYTES | NUMBER | Yes | ||
SMALL_READ_REQUESTS | NUMBER | Yes | ||
SMALL_WRITE_REQUESTS | NUMBER | Yes | ||
LARGE_READ_REQUESTS | NUMBER | Yes | ||
LARGE_WRITE_REQUESTS | NUMBER | Yes | ||
PQS_QUEUED | NUMBER | |||
PQ_QUEUED_TIME | NUMBER | |||
PQ_QUEUE_TIME_OUTS | NUMBER | |||
PQS_COMPLETED | NUMBER | |||
PQ_SERVERS_USED | NUMBER | |||
PQ_ACTIVE_TIME | NUMBER | |||
CON_DBID | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, SEQUENCE#
, CONSUMER_GROUP_ID
, CONSUMER_GROUP_NAME
, REQUESTS
, CPU_WAIT_TIME
, CPU_WAITS
, CONSUMED_CPU_TIME
, YIELDS
, 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
, 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_QUEUED
, PQ_QUEUED_TIME
, PQ_QUEUE_TIME_OUTS
, PQS_COMPLETED
, PQ_SERVERS_USED
, PQ_ACTIVE_TIME
, CON_DBID
, CON_ID
FROM SYS.INT$DBA_HIST_RSRC_CON_GROUP;
|
|
|