Oracle 视图 V$RSRC_PDB 官方解释，作用，如何使用详细说明
本站中文解释
_RLU
V$RSRC_PDB_RLU是一种oracle视图，用于查询有关资源调度中处理原始逻辑单元（ORLU）的信息。原始逻辑单元是用来表示数据库中各个Pluggable Database（PDB）及其资源之间关系的一个抽象概念，它们通常由交换池，可容纳的PDB，可访问的PDB或可暂存器PDB构成。
V$RSRC_PDB_RLU可以用于帮助开发和管理团队更好地理解资源调度需求和PDB数据的场景。它们提供了有关当前处理ORLUs的一些重要信息，例如当前ORLU状态，处理此ORLU的PDB及其内容等。管理员可以通过V$RSRC_PDB_RLU视图来监视和控制数据库中符合ORLU标准的所有处理。
官方英文解释
V$RSRC_PDB displays data related to currently active resource consumer groups by pluggable database (PDB).
When the STATISTICS_LEVEL is set to TYPICAL or ALL, this view contains information about CPU utilization and wait times even when no Resource Manager plan is set or when the Resource Manager plan does not monitor CPU or session resources.
Statistics in V$RSRC_PDB are reset when a multitenant container database (CDB) changes its resource plan. They are not impacted by PDB resource plan changes.
V$RSRC_PDB covers the same time period for all PDBs. This view is specifically designed for comparing statistics across different PDBs.
Since V$RSRC_PDB does not contain information at the consumer group level, it is not useful for comparing consumer groups inside a PDB.
| Column | Datatype | Description |
|---|---|---|
|
|
|
PDB name |
|
|
|
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. When CPU resources are not being actively managed, this value is set to zero. |
|
|
|
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. When CPU resources are not being actively managed, this value is set to zero. |
|
|
|
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. When CPU resources are not being actively managed, this value is set to zero. |
|
|
|
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 |
|
|
|
Total number of completed parallel statements in the consumer group |
|
|
|
Total number of parallel servers used by completed parallel statements in the consumer group |
|
|
|
Number of times that sessions in the consumer group were queued when trying to run parallel statements |
|
|
|
Cumulative sum of the parallel active times for all completed parallel statements in the consumer group (in milliseconds) |
|
|
|
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 |
|
|
|
Number of active parallel statements in the consumer group. This value does not include parallel statements that are never queued, such as GV$ queries. |
|
|
|
Number of active parallel servers in the consumer group. This value does not include servers running parallel statements that are never queued, such as GV$ queries. |
|
|
|
Number of sessions in the consumer group that are waiting in the parallel statement queue trying to run parallel statements |
|
|
|
The current SGA usage by this PDB in bytes |
|
|
|
The current usage of buffer cache by this PDB in bytes |
|
|
|
The current usage of shared pool by this PDB in bytes |
|
|
|
The current usage of PGA by this PDB in bytes |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$RSRC_CONSUMER_GROUP”
