VIEW: SYS.DBA_HIST_RSRC_CONSUMER_GROUP

Source

View Text - Preformatted

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 INT$DBA_HIST_RSRC_CON_GROUP

View Text - HTML Formatted

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 INT$DBA_HIST_RSRC_CON_GROUP