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'
'프로그램 > 오라클 관련팁' 카테고리의 다른 글
| 오라클 TABLE에 걸쳐있는 constraint 찾고, disable 하기 (1) | 2011.06.08 |
|---|---|
| free buffer waits 튜닝 관련 자료 (1) | 2011.05.31 |
| 오라클 이벤트 클래스( WAIT_EVENT_CLASS ) (0) | 2011.05.31 |
| 이벤트 클래스 "Commit"에 대한 "Database Time Spent Waiting (%)" 측정 단위는 N에 있습니다. (0) | 2011.05.31 |
| ORACLE JOB 조회, JOB 등록, JOB 삭제, JOB 실행, JOB 변경 (0) | 2011.05.26 |
| 오라클 tablespace 용량확인 쿼리 (0) | 2011.05.12 |