confused about flushing of redo log buffer
(Oracle 9.2)
hi guys,
I always thought that when a transaction committed, the whole redo log buffer was flushed to disk.
However, the Oracle documentation says:
When a user issues a COMMIT statement, LGWR puts a commit record in the redo log buffer and writes it to disk immediately, along with the transaction's redo entries
This to me suggests that only that transaction's redo entries are written to disk, and not the whole redo log buffer.
Can someone please tell me what really happens?
thanks