DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Redo log files

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    If my redo log size is too small and checkpoint can't frequetly switch, what is the best way to fix this problem ??? Should I add more redo log files ??? I need two or more solutions of how to fix this problem is possible. Please give me some detail.

    Your help will be greatly appreciated.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by mike73
    I need two or more solutions of how to fix this problem is possible
    Fortunately for you, there are two solutions.
    1. add more log groups of the same size
    2. add more log groups of a larger size and then drop the existing log groups.
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

Posting Permissions

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


Click Here to Expand Forum to Full Width