5.40 DBA_HIST_RSRC_METRIC
DBA_HIST_RSRC_METRIC
displays information about historical Resource Manager metrics for the past hour.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Begin time of the interval |
|
|
|
End time of the interval |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
A sequential counter that uniquely describes the |
|
|
|
Consumer group object ID (a unique number, consistent across database shutdowns and startups) |
|
|
|
Cumulative amount of CPU time consumed by all sessions in the consumer group, in milliseconds |
|
|
|
Cumulative amount of time that sessions waited for CPU because of resource management, in milliseconds. This does not include waits due to latch or enqueue contention, I/O waits, and so on. When CPU resources are not being actively managed, this value is set to zero. |
|
|
|
Average number of sessions in the consumer group that are currently running |
|
|
|
Average number of sessions in the consumer group that are waiting for CPU due to resource management. When CPU resources are not being actively managed, this value is set to zero. |
|
|
|
Average percentage CPU consumed by the consumer group |
|
|
|
I/O requests |
|
|
|
I/O megabytes |
|
|
|
I/O operations per second during the previous minute for this PDB |
|
|
|
I/O megabytes per second during the previous minute for this PDB |
|
|
|
The average number of parallel statements that were running during the 1-minute metric window |
|
|
|
The average number of parallel statements that were queued during the 1-minute metric window |
|
|
|
The average number of parallel servers that were actively running as part of a parallel statement during the 1-minute metric window |
|
|
|
The average number of parallel servers that were requested by queued parallel statements during the 1-minute metric window |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|