Oracle 视图 V$CON_SYSTEM_WAIT_CLASS 官方解释,作用,如何使用详细说明
本站中文解释
ES
Oracle视图V$CON_SYSTEM_WAIT_CLASSES用于展示每个连接会话在等待类别下的等待时间。这个视图存储每个会话会话等待类别的等待汇总信息,如CPU,其他CPU,网络,操作系统等。通过查询视图V$CON_SYSTEM_WAIT_CLASSES,管理者可以查看某个会话下的不同等待类别的等待时长。
使用V$CON_SYSTEM_WAIT_CLASSES的方法如下:
1. 首先需要定位到某个特定的会话,即获取会话的SID:SELECT SID FROM V$SESSION WHERE USERNAME = ‘Admin’
2. 然后使用SID获取这个会话等待类别的统计信息:SELECT * FROM V$CON_SYSTEM_WAIT_CLASSES WHERE SID = [SID];
3. 最后可以由该视图获取此会话在各个等待类别上的等待时间,从而判断此会话在每个等待类别上的平均等待时长。
官方英文解释
V$CON_SYSTEM_WAIT_CLASS
displays the time totals for each registered wait class in a container.
Column | Datatype | Description |
---|---|---|
|
|
Identifier of the wait class |
|
|
Number of the wait class |
|
|
Name of the wait class |
|
|
Total number of waits from this wait class |
|
|
Total amount of time spent in waits from this wait class (in hundredths of a second) |
|
|
Total amount of time spent in waits from this wait class (in microseconds) |
|
|
Total amount of CPU time consumed while implementing waits from this wait class (in microseconds) |
|
|
Total number of waits from this wait class, from foreground sessions |
|
|
Total amount of time spent in waits from this wait class, from foreground sessions (in hundredths of a second) |
|
|
Total amount of time spent in waits from this wait class, from foreground sessions (in microseconds) |
|
|
Total amount of CPU time consumed while implementing waits from this wait class, from foreground sessions (in microseconds) |
|
|
When queried from a non-CDB, time totals for each registered wait class in that instance are returned, and the When queried from the root of a CDB, time totals for each registered wait class in every container is returned, and the When queried from a PDB, time totals for each registered wait class in that PDB are returned, and the |