Wait Events的分类及分类依据

最新推荐文章于 2023-03-25 15:20:54 发布

转载最新推荐文章于 2023-03-25 15:20:54 发布 · 149 阅读

本文详细介绍了数据库中等待事件的各种分类，包括行政管理、应用、集群、提交确认等类别，并提供了各类别下常见等待事件实例，有助于进行高级别的等待事件分析。

To enable easier high-level analysis of the wait events, the events are grouped into
classes. The wait event classes include: Administrative, Application, Cluster, Commit,
Concurrency, Configuration, Idle, Network, Other, Scheduler, System I/O, and User
I/O.

The wait classes are based on a common solution that usually applies to fixing a
problem with the wait event. For example, exclusive TX locks are generally an
application level issue and HW locks are generally a configuration issue.
The following list includes common examples of the waits in some of the classes:
■ Application: locks waits caused by row level locking or explicit lock commands
■ Commit: waits for redo log write confirmation after a commit
■ Idle: wait events that signify the session is inactive, such as SQL*Net message
from client
■ Network: waits for data to be sent over the network
■ User I/O: wait for blocks to be read off a disk

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1004776/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1004776/