Top 5 Timed Events - log file switch (checkpoint incomplete)
Waits for this wait indicates that the process is waiting for the log file switch to complete, but the log file switch is not possible because the checkpoint process for that log file has not completed. You may see this event when the redo log files are sized too small. One has to go below the AWR and look for log swtiches. Ideally the log switches should be 2 or 3 for hour.
Waits for this wait indicates that the process is waiting for the log file switch to complete, but the log file switch is not possible because the checkpoint process for that log file has not completed. You may see this event when the redo log files are sized too small. One has to go below the AWR and look for log swtiches. Ideally the log switches should be 2 or 3 for hour.
The log switches under the Instance Activity Stats show that there are 33 switches happened during an hour which mean every 2 minutes there is switch. We need to increase the size of the online redo log files to get rid of this wait event as well as improve the performance of the database.
No comments:
Post a Comment