5.41 DBA_HIST_RSRC_PDB_METRIC
DBA_HIST_RSRC_PDB_METRIC
displays information about historical Resource Manager metrics for the past hour by PDB.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Begin time for the metric value |
|
|
|
End time for the metric value |
|
|
|
Size of the time period |
|
|
|
A sequential counter that uniquely describes the |
|
|
|
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 operations per second during the previous minute for this PDB |
|
|
|
I/O megabytes per second during the previous minute for this PDB |
|
|
|
Indicates how much of the I/O per second in the current PDB was exempted from throttling. For example, if the value in the I/O throttling is defined by the |
|
|
|
Indicates how many megabytes of I/O executed per second in the current PDB were exempted from throttling. For example, if the value in the I/O megabytes per second throttling is defined by the |
|
|
|
Average throttle time per I/O operation in milliseconds 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 current SGA usage for this PDB in bytes |
|
|
|
The current usage of the buffer cache by this PDB in bytes |
|
|
|
The current usage of the shared pool by this PDB in bytes |
|
|
|
The current PGA usage for this PDB in bytes |
|
|
|
Resource Manager plan identifier |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|