Products documentation

This monitor will check the time interval between log switches and notify if it happens too often.

<lu> <li>Archive logs are archived redo(online) log files.</li> <li>In redo log files are all changes that happened to your data.</li> <li>If your database is in archivelog mode, than redo logs can't be overwritten, they are archived in some other location when they are full.</li> <li>Redo and archive logs are used in various database recovery scenarios</li> </lu>

<lu> <li>In a production environment it is important to size your online redo log files to ensure that the frequency of redo log switches is not more than 5 log switches per hour during peak DML activity.</li> <li>A log switch is the point at which the database stops writing to one redo log file and begins writing to another. …</li> <li>You can also force logs witches manually.</li> <li>Oracle Database assigns each redo log file a new log sequence number every time a log switch occurs and LGWR begins writing to it.</li> </lu>

Oracle's recommendation is that the interval for log switches be 15 to 30 minutes apart, with a maximum of four log switches per hour

Create a new rule and set the thresholds accordingly. You must use multi-threshold syntax with this monitor.