Home Discussions Questions & Answers Redo Log Switch Analysis

Redo Log Switch Analysis

Avatar photoCustomer October 31, 2024 at 8:20 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support November 2, 2024 at 4:01 am  

      Yes, the DBA Log Switches report is available to review the frequency of log file switches.

    • Avatar photoCustomer November 3, 2024 at 12:16 pm  

      If we run in NOARCHIVELOG mode, how is the approximate redo rate calculated for capacity planning purposes?

    • Support November 4, 2024 at 7:22 am  

      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.

    • Avatar photoCustomer November 4, 2024 at 11:23 am  

      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?

    • Support November 6, 2024 at 6:21 am  

      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.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: