ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Database Statistics

Database Statistics

原创 Linux操作系统 作者:ygzhou518 时间:2012-02-15 11:53:59 0 删除 编辑

Wait Events

Wait events are statistics that are incremented by a server process or thread to indicate that it had to wait for an event to complete before being able to continue processing. Wait event data reveals various symptoms of problems that might be impacting performance, such as latch contention, buffer contention, and I/O contention.

To enable easier high-level analysis of the wait events, events are grouped into classes.

The 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

Wait event statistics for an instance include statistics for both background and foreground processes. Because you would typically focus your effort in tuning foreground activities, overall instance activity is broken down into foreground and background statistics in the relevant V$ views to facilitate tuning.

The V$SYSTEM_EVENT view shows wait event statistics for the foreground activities of an instance and the wait event statistics for the instance. The V$SYSTEM_WAIT_CLASS view shows these foreground and wait event instance statistics after aggregating to wait classes. V$SESSION_EVENT and V$SYSTEM_WAIT_CLASS show wait event and wait class statistics at the session level.

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

下一篇: Database Statistics
请登录后发表评论 登录
全部评论

注册时间:2011-02-11

  • 博文量
    167
  • 访问量
    360202