Re: Regarding TRANSACTION RECOVERY >>The point being, Oracle can write to disk whenever it deems the most
>>performant time to do so because it is 100% protected by the redologs.
>>Is this not correct?
Typically, DBWn writes to disk dirty blocks on log switches, when there
are few database buffers free, and by log_checkpoint_interval &
log_checkpoint_timeout, but I was referring to log writes(LWR), not to
block writes (DBWn / checkpoints).
HTH
Cheers.
Carlos. |