Redo Logging I/O-Related Wait Events
'log file sequential read' and 'log file single write'
Both these Wait Events are I/O-related so they are likely to appear together with 'log file parallel write' if there is I/O contention on the redo logs. Follow the same guidelines for tuning them.
'switch logfile command' ,'log file switch completion' and 'log file switch (clearing log file)'
More LGWR I/O-related Wait Events, tune as before.
'log file switch (checkpoint incomplete)'
This Wait Event occurs when checkpointing activities are not occurring quickly enough.
For guidelines on tuning checkpoint operations please refer to:
Document 147468.1 Checkpoint Tuning and Troubleshooting Guide
Document 76713.1 8i Parameters that Influence Checkpoints
Document 76713.1 8i Parameters that Influence Checkpoints
'log switch/archive' and 'log file switch (archiving needed)'
These Wait Events occur when archiving is enabled and indicate that archiving is not performing fast enough.
For guidelines on tuning archiving operations please refer to:
Document 45042.1 Archiver Best Practices
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29337971/viewspace-1816627/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Buffer Cache I/O-Related Wait EventsAI
- wait eventsAI
- Oracle RAC Wait EventsOracleAI
- Data Guard Wait EventsAI
- Parallel Query Wait EventsParallelAI
- Tuning I/O-related waitsAI
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- 【DATAGUARD】Data Guard Wait EventsAI
- 幾個ORACLE wait eventsOracleAI
- High "Resmgr:Cpu Quantum" Wait EventsAI
- 轉:latch wait events 說明分析AI
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- zt_關於wait events asynch descriptor resize_wait eventAI
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- commit_write,commit_logging,commit_wait引數和oracle redo行為MITAIOracle Redo
- wait event_Additional Statistics_that do not have corresponding wait eventsAI
- oracle中 Wait Events 和可能原因(oracle doc)OracleAI
- Troubleshooting I/O-related waits [ID 223117.1]AI
- Wait Events的分類及分類依據AI
- 0317Library Cache Pin/Lock Wait EventsAI
- Direct I/O and Redo writes.
- Oracle Enqueues Wait Events 三 enq: TX - row lock contentionOracleENQAI
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Master Note Parallel Execution Wait Events [ID 1097154.1]ASTParallelAI
- oracle11g_Descriptions of Wait Events_等待事件全列表OracleAI事件
- alter session set events語句dump REDO日誌檔案頭資訊示例Session
- Deal With "SGA: allocation forcing component growth" Wait Events_1270867.1AI
- Statspack報告分析—第6部分: Wait Events - Complete listAI
- 11g append 和常規insert在logging FORCE_LOGGING產生redo量差異APP
- oracle 9i臨時表產生過多redoOracle
- Statspack報告分析—第四部分:Top 5 Wait Events 5大等待事件AI事件
- oracle eventsOracle
- 【WAIT】wait eventAI
- 在歸檔模式下設定_disable_logging=true導致redo corrupt的解決辦法模式
- ORACLE EVENTS(轉)Oracle
- oracle set eventsOracle