Wednesday, February 13, 2008

Classes of Wait Events

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 Cluster 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')

Scheduler
Resource Manager related waits (for example, 'resmgr: become active')

System I/O
Waits for background process IO (for example, DBWR wait for 'db file parallel write')

User I/O
Waits for user IO (for example 'db file sequential read')