幾個ORACLE wait events
db file sequential read
是個非常常見的I/O相關的等待事件,通常顯示與單個資料塊相關的讀取操作,在大多數的情況下,讀取一個索引塊或者通過索引讀取一個資料塊時,都會記錄這個等待。
這個等待事件有3個引數P1,P2,P3,其中P1代表Oracle要讀取的檔案的絕對檔案號,P2代表Oracle從這個檔案中開始讀取的起始資料塊號,P3代表讀取的BLOCK數量,通常這個值為1,表明是道單個BLOCK被讀取。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26661112/viewspace-716177/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC Wait EventsOracleAI
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- wait eventsAI
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- oracle中 Wait Events 和可能原因(oracle doc)OracleAI
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- Data Guard Wait EventsAI
- Parallel Query Wait EventsParallelAI
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- 【DATAGUARD】Data Guard Wait EventsAI
- Oracle Enqueues Wait Events 三 enq: TX - row lock contentionOracleENQAI
- oracle11g_Descriptions of Wait Events_等待事件全列表OracleAI事件
- High "Resmgr:Cpu Quantum" Wait EventsAI
- 轉:latch wait events 說明分析AI
- zt_關於wait events asynch descriptor resize_wait eventAI
- Buffer Cache I/O-Related Wait EventsAI
- oracle eventsOracle
- wait event_Additional Statistics_that do not have corresponding wait eventsAI
- ORACLE EVENTS(轉)Oracle
- oracle set eventsOracle
- Wait Events的分類及分類依據AI
- 0317Library Cache Pin/Lock Wait EventsAI
- Master Note Parallel Execution Wait Events [ID 1097154.1]ASTParallelAI
- Redo Logging I/O-Related Wait EventsAI
- dump oracle events(轉)Oracle
- oracle wait!OracleAI
- Oracle跟蹤事件 -- set eventsOracle事件
- oracle幾個函式Oracle函式
- Deal With "SGA: allocation forcing component growth" Wait Events_1270867.1AI
- Statspack報告分析—第6部分: Wait Events - Complete listAI
- Oracle所有診斷事件列表eventsOracle事件
- alter session set events /Oracle跟蹤SessionOracle
- [zt]Oracle跟蹤事件 - set eventsOracle事件
- Oracle跟蹤事件:set events 整理Oracle事件
- oracle幾個有用的命令Oracle
- oracle的幾個服務Oracle