Log Buffer Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 22

Thread: Log Buffer Size

Threaded View

  1. #18
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by KenEwald
    I'm not sure I explained my question properly, let me try it this way.

    Let's compare two systems that generate 3gb/hr.

    One has 3 - 100mb redo logs and the other has 3 - 1gb redo logs.

    If the transactions were evenly distriubted over time, the first system would generate a log file every 2 minutes. The other every 20 minutes.

    What's the rationale for sand-bagging I/O? Would it be better to more evenly distribute it over time?

    Just curious,

    Ken
    Huh? Define Sand-bagging i/o?
    It all depends on how the system is layed out...
    Sure I/O will be terrible if you share drives between the arch file systems and redo logs (raw, file system).... But If you don't and have dedicated devices for each, then what does it matter if occasionally I/O spikes for 10 seconds to generate an arch log?

    It better to generate fewer archive logs to reduce checkpoints, but in the end this must be ballanced by many other factors(ie data guard, backups etc).
    ..

    I guess all i'm saying is a 2M log file is generally a bad idea, no matter what the system. It might be ok for say a read only or a DW where all loads are direct path and very little redo is generated.

    Hope this helps,
    Ken
    Last edited by ixion; 10-16-2006 at 02:32 PM.

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