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

Thread: Redo log files

  1. #1
    Join Date
    Aug 2001
    Posts
    391
    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,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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