logfile switches
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: logfile switches

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    how often should logfiles switch?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When the redo log file gets filled.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The conventional wisdom is that logfiles should switch every 15 - 20 minutes. Some people prefer to have their logs switch more frequently, some like less frequently. My rule of thumb is that the logfiles should be large enough so you don't see "Checkpoint not complete" in your alert.log during periods of heavy activity.
    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."

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    It totally depends upon the activity of the database. Log file contains the redo generated/changes that were made to the database. I mean during the busy hours it will be switching faster than off peak hours, as it fills quickly in business hours. 30 Minutes is reasonable time for log switches. Its not again hard and fast rule.

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