6.42 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 of the interval |
|
|
|
End time of the interval |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
A sequential counter that uniquely describes the |
|
|
|
Cumulative amount of CPU time consumed by all sessions in the PDB, 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 PDB that are currently running |
|
|
|
Average number of sessions in the PDB 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 of CPU consumed by the PDB, with respect to the total number of CPUs in the system |
|
|
|
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
|
|
|
|
Maximum value of |