5.39 DBA_HIST_RSRC_CONSUMER_GROUP
DBA_HIST_RSRC_CONSUMER_GROUP
displays historical information about Resource Manager consumer groups.
This view contains snapshots of V$RSRC_CONS_GROUP_HISTORY
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
A sequential counter that uniquely describes the |
|
|
|
Consumer group object ID (a unique number, consistent across database shutdowns and startups) |
|
|
|
Name of the consumer group |
|
|
|
Cumulative number of requests that were executed in the consumer group |
|
|
|
Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
|
|
|
Cumulative number of times all sessions in the consumer group had to wait for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
|
|
|
Cumulative amount of CPU time consumed by all sessions in the consumer group (in milliseconds) |
|
|
|
Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration |
|
|
|
Number of times that sessions in the consumer group were queued because the consumer group reached its active session limit |
|
|
|
Number of times that queries in the consumer group were cancelled because the consumer group reached its |
|
|
|
Number of switches into the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches out of the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches into the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches out of the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches into the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches out of the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches into the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches out of the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches into the consumer group because of the Resource Manager plan's |
|
|
|
Number of switches out of the consumer group because of the Resource Manager plan's |
|
|
|
The number of sessions that were killed because their PGA allocation exceeded the PGA limit specified in the Resource Plan’s |
|
|
|
Number of times that SQL queries running in the consumer group were aborted because they exceeded the Resource Manager plan's |
|
|
|
Number of times that sessions running in the consumer group were terminated because they exceeded the Resource Manager plan's |
|
|
|
Number of times that sessions in the consumer group were killed because they were idle for too long (reached |
|
|
|
Number of times that sessions in the consumer group were killed because they were idle too long (reached |
|
|
|
Total amount of time that sessions in the consumer group have spent in the QUEUED state because of the active session limit (in milliseconds) |
|
|
|
Number of times that requests from sessions in the consumer group timed out because they were queued for too long (reached |
|
|
|
Cumulative I/O wait time (in milliseconds) |
|
|
|
Total number of wait requests |
|
|
|
Number of single block megabytes read |
|
|
|
Number of single block megabytes written |
|
|
|
Number of multiblock megabytes read |
|
|
|
Number of multiblock megabytes written |
|
|
|
Number of single block read requests |
|
|
|
Number of single block write requests |
|
|
|
Number of multiblock read requests |
|
|
|
Number of multiblock write requests |
|
|
|
Number of times that sessions in the consumer group were queued when trying to run parallel statements |
|
|
|
Total amount of time that sessions in the consumer group were queued when trying to run parallel statements (in milliseconds) |
|
|
|
Number of times that parallel statements from sessions in the consumer group timed out because their queue time exceeded the Resource Manager plan's |
|
|
|
Total number of completed parallel statements in the consumer group |
|
|
|
Total number of parallel servers used by completed parallel statements in the consumer group |
|
|
|
Cumulative sum of the parallel active times for all completed parallel statements in the consumer group (in milliseconds) |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: