【WAIT】wait event
| Wait Event | R/W |
Synchronous /Asynchronous |
Singleblock/ Multiblock |
Elapsed Time (with 1000+ waits per hour) |
|---|---|---|---|---|
| control file parallel write |
Write |
Asynchronous | Multi | < 15ms |
| control file sequential read |
Read |
Synchronous | Single | < 20 ms |
| db file parallel read | Read | Asynchronous | Multi | < 20 ms |
| db file scattered read | Read | Synchronous | Multi | < 20 ms |
| db file sequential read | Read | Synchronous | Single | < 20 ms |
| direct path read | Read | Asynchronous | Multi | < 20 ms |
| direct path read temp | Read | Asynchronous | Multi | < 20 ms |
| direct path write | Write | Asynchronous | Multi | < 15 ms |
| direct path write temp | Write | Asynchronous | Multi | < 15 ms |
| log file parallel write | Write | Asynchronous | Multi | < 15 ms |
|
Exadata Related |
||||
| cell smart table scan | Read | Asynchronous | Multi | < 1 ms |
| cell single block physical read | Read | Synchronous | Single | < 1 ms |
| cell multiblock physical read | Read | Synchronous | Multi | < 6 ms |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29487349/viewspace-2143178/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- enqueue wait event .ENQAI
- wait for stopper event to be increasedAI
- Subject: "class slave wait" is the top wait event on AWR snapshotAI
- oracle wait event 等待事件OracleAI事件
- wait event ---asynch descriptor resizeAI
- wait event:gc buffer busyAIGC
- Oracle Wait Event - TuningOracleAI
- Wait event:read by other sessionAISession
- 等待事件 (wait event) [final]事件AI
- Wait Event "PX Deq: Execution Msg"AI
- 遭遇DFS LOCK HANDLE wait event,AI
- zt_關於wait events asynch descriptor resize_wait eventAI
- wait event_Additional Statistics_that do not have corresponding wait eventsAI
- 12.2 wait event ‘PGA memory operation’AI
- Common Oracle Wait Event Descriptions(zt)OracleAI
- wait event監測效能瓶頸AI
- log buffer space wait event等待事件AI事件
- Wait Event Enhancements in Oracle 10g（zt）AIOracle 10g
- v session_wait v session_event v system_eventSessionAI
- v$session_event , v$system_event , v$session_waitSessionAI
- Oracle10g Wait Event Data Collection ProcedureOracleAI
- oracle wait event之db file sequential readOracleAI
- 查詢等待事件(wait event)相關的SQL - v$session_wait, v$rowcache,v$sqltext事件AISQLSession
- 【蓋國強】Oracle Wait Event:Data file init writeOracleAI
- Wait event (二) 摘自官檔 Oracle版權所有AIOracle
- V$SESSION.STATUS='ACTIVE' AND WAIT_EVENT='Idle'SessionAI
- 【go語言】wait，wait for meGoAI
- 轉eygle大師_wait event_db file init writeAI
- direct path read wait event 的處理辦法AI
- v$session_wait和v$session_event檢視SessionAI
- db file sequential read wait event等待事件之二AI事件
- oracle dg後臺程式及wait event--轉載-精OracleAI
- oracle wait event的一些動態效能檢視OracleAI
- fork waitAI
- oracle wait!OracleAI
- wait eventsAI
- wait() and notify()AI
- 幾個重要檢視（V$SYSTEM_EVENT V$SESSION_EVENT V$SESSION_WAIT）SessionAI