Classes of Oracle Wait Events

Every oracle wait event belongs to a class of wait event. Here is the list of classes of oracle wait events.
1)Administrative: DBA commands cause users to wait. Example: index rebuild

2)Application: User application codes cause to wait. Example: row level lock

3)Cluster: Waits related to Real Application Cluster resources. Example: gc cr block busy

4)Commit: After issuing commit wait for redo log write confirmation. Example: log file sync

5)Concurrency: Waits for internal database resources. Example: Latch wait.

6)Configuration: Waits caused by inadequate configuration of database or instance resources Example: Undersized log file size, undersized shared pool size.

7)Idle: Waits that signify the session is inactive, that is session waiting for work. Example: SQL*Net message from client.

8)Network: Waits related to network messaging. Example: SQL*Net more data to dblink.

9)Other: Waits which should not typically occur on a system. Example:wait for EMON to spawn.

10)Scheduler: Resource Manager related waits. Example: resmgr: become active.

11)System I/O: Waits for background process IO. Example: DBWR waits for 'db file parallel write'.

12)User I/O: Waits for user IO. Example: 'db file sequential read'
Related Documents

New features in Oracle database administration in 11g
DDL with the WAIT option in 11g -DDL_LOCK_TIMEOUT

http://arjudba.blogspot.com/2009/11/ora-01012-not-logged-on.html

http://arjudba.blogspot.com/2008/07/process-and-runtime-limits.html
http://arjudba.blogspot.com/2008/04/user-resource-limits-in-oracle.html

http://arjudba.blogspot.com/2008/07/classes-of-oracle-wait-events.html

http://arjudba.blogspot.com/2008/05/what-is-enq-tx-row-lock-contention.html