Re: Importance of L.Log Buffer When database has No Buff. Mode

Even with unbuffered logging, you still use the log buffer. It's only with the commit that you write the buffer to the physical log file. A lot of this has to do with the size of your rows, the number of rows updated per transaction, etc... It really doesn't hurt to have the log buffer size over-configured because we only write out how much space in the log buffer is actually used. Gokhan TERCAN wrote: > Hi, > > Does anybody have any idea > what the importance of logical log buffers = > > when the database is in unbuffered mode ? > What is the recommended size for the buffers in > this situation ? > > I have 200 GB database which is unbuffered and > Logical log buffer size is 16 K > > Thanks, > Gokhan > > ____________________________________________________________________ > Get free e-mail and a permanent address at http://www.amexmail.com/?A=3D1=