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

[Gokhan TERCAN]

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=

[Madison Pruet]

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.