Home › Discussions › Questions & Answers › Redo Log Switch Analysis
Customer · · Questions & Answers · 5 replies
We are optimizing our log file configuration and need to track the frequency of redo log file switches historically. Is there a Blitz Report that tracks this?
Yes, the DBA Log Switches report is available to review the frequency of log file switches.
If we run in NOARCHIVELOG mode, how is the approximate redo rate calculated for capacity planning purposes?
In NOARCHIVELOG mode, the DBA Archive / Redo Log Rate report calculates the approximate redo rate based on the number of log switches per hour and the log file size.
We also need an automated way to monitor the alert log for critical messages that occur since the last check. Which report should I schedule?
Schedule the DBA Alert Log report. You could schedule it in incremental mode to send an email with errors that occurred since the last run.
Sign in with LinkedIn or Google to take part.
