Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Is our redo log not enough


    My database is running on 8.1.7

    I have 10M redo log files with 256K log buffer. During non-busy period it generates 1 switch every 30 minutes, but during busy period it generates 10 switch every one minutes.

    Is my redo log files correct? How to balance the correct size?

  2. #2
    Join Date
    Sep 2003
    The Netherlands

    in general 1 switch per minute is too much. But then again, if that only happens during 10 busy minutes a day, it's not really a problem. The redo log size is somewhat large, comparing to the buffersize.
    I would recommend to increase the buffersize and check out how long and frequent the changes come after that and what the busy houres are and how long the are.

    Hope this helps.
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts