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
Received on Mon Sep 15 1997 - 00:00:00 CDT
