Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Log Switch Time Alarm

The Log Switch Time alarm occurs if the amount of time spent waiting for log switch events exceeds a threshold.

A log switch must occur whenever a log file is full. Usually the log switch time is trivial, but it can become significant in the following circumstances:

  • The next redo log to be used is not available because the checkpoint that started when the log was switched is not complete, or
  • The redo log has not yet been archived.

These problems usually occur when redo log I/O rates are sub-optimal, or when the number or size of redo logs is insufficient. For more information, see Improve Redo Log Writer Performance.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating