Oracle Switch Intervals


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

Differences between Archive and Redo logs

  • Archive logs are archived redo(online) log files.
  • In redo log files are all changes that happened to your data.
  • 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.
  • Redo and archive logs are used in various database recovery scenarios
  • 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.
  • A log switch is the point at which the database stops writing to one redo log file and begins writing to another. …
  • You can also force logs witches manually.
  • Oracle Database assigns each redo log file a new log sequence number every time a log switch occurs and LGWR begins writing to it.

Oracle recommendation

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

Configuration hints

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

Atomic fields

Period (hours)The period of time in the past to look for switch interval. Make sure the period overlaps with the monitor schedule so you won't miss any dump

Surveillance table

ActiveTo enable/disable a rule.
Max switches per hourThe threshold for the maximum number of switches per hour.
Max interval with no switchesThe threshold for the maximum number of time without switches.
Average switches per hourA threshold for the maximum average time interval between switches per hour.
Auto clearIf checked, the alarm will be cleared as soon as the alarm condition is not met anymore.
Alarm tagThis field allows to add custom text within the alarm message. %MSG% variable will containthe actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tagwill be used as prefix.
AlarmTo enable alarm sending
MetricTo enable metric sending
ReportIf checked, this line of surveillance will used for showing threshold and severity in the daily report

Generated metrics

/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/oracle/oracleswitchintervals.txt · Last modified: 2022/11/04 10:20 by rbariou