Re: Redo log buffers

In article <341CDFFB.5573109D_at_KirchGruppe.de>,   Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de> wrote:
>
> rsenn wrote:
> >
> > Do the redo log buffers flush from memory to disk every few seconds, or
> > only when they fill up and the oldest data is moved out? [ If I set
> > the redo log buffers to 1M or maybe more, would I be at risk of losing
> > 1M or maybe more of recent activity in the event of an abnormal abort? ]
> They will be flushed when either
> - a third of the buffers are filled
> - a transaction is finished (either by rollback or commit)
> Therefore, if your transaction is finished, it is written to disk in any
> case (before this the commit or rollback command would not return and
> therefore it would not be considered finished). If it is still open and
> the system stops abnormally, your transaction should not be recorded to
> the redologs anyway.
> --
> Martin Haltmayer

Martin can you explain what do you mean "a third of the buffers are filled"?

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet