Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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