Classes of Wait Events
来源:互联网 发布:unity3d 导入fbx 编辑:程序博客网 时间:2024/05/21 08:59
Classes of Wait Events
Every wait event belongs to a class of wait event. The following list describes each of the wait classes.
Administrative
Waits resulting from DBA commands that cause users to wait (for example, an index rebuild)
Application
Waits resulting from user application code (for example, lock waits caused by row level locking or explicit lock commands)
Cluster
Waits related to Real Application Clusters resources (for example, global cache resources such as 'gc cr block busy')
Commit
This wait class only comprises one wait event - wait for redo log write confirmation after a commit (that is, 'log file sync')
Concurrency
Waits for internal database resources (for example, latches)
Configuration
Waits caused by inadequate configuration of database or instance resources (for example, undersized log file sizes, shared pool size)
Idle
Waits that signify the session is inactive, waiting for work (for example, 'SQL*Net message from client')
Network
Waits related to network messaging (for example, 'SQL*Net more data to dblink')
Other
Waits which should not typically occur on a system (for example, 'wait for EMON to spawn')
Queue
Contains events that signify delays in obtaining additional data in a pipelined environment. The time spent on these wait events indicates inefficiency or other problems in the pipeline. It affects features such as Oracle Streams, parallel queries, orDBMS_PIPE
PL/SQL packages.
Scheduler
Resource Manager related waits (for example, 'resmgr: become active')
System I/O
Waits for background process I/O (for example, DBWR wait for 'db file parallel write')
User I/O
Waits for user I/O (for example 'db file sequential read')
- Classes of Wait Events
- Descriptions of Wait Events
- wait events
- Oracle Common wait events
- Data Guard Wait Events
- wait events in oracle
- Wrong wait events in 11.2 ("cursor: mutex S" instead of "cursor: mutex X") (文档 ID 9591812.8)
- Common Wait Events(读书总结)
- scripts for query proportion of the on-idle wait time is taken up by these wait classes
- Common Wait Events---buffer busy waits
- Common Wait Events---db file scattered read
- Oracle-Wait Events and Potential Causes
- 等待事件统计信息--Wait Events Statistics
- Association Classes of UML
- Hierarchy of Classes
- Overview of UIKit Classes
- Overview of UIKit Classes
- The Primer of Classes
- C#图像细化:Hilditch细化算法
- Tutorial: Debugging the U-Boot Universal Boot Loader (最全的uboot调试方法,找了好久)
- 为嵌入式操作系统linux(二)
- Descriptions of Common Wait Event Parameters
- modprobe
- Classes of Wait Events
- Android待机的suspend_sys_sync_queue分析
- oracle创建索引 .
- socket python
- Mybatis学习总结
- UILocalNotification 实现 本地 提醒
- LLDB和GDB比较
- Windows平台字符透明编程大总结
- 关于uint与int