讨论:LGWR什么时候写redo log buffer 到 online redo log files?
8i Sybex书上说:
When a user transaction issues a COMMIT
When the redo log buffer is one-third full
When the DBWn process writes dirty buffers to disk
Every three seconds
9i Sybex书上说:
A user commits a transaction, even if this is the only transaction in the
log buffer.
The redo log buffer becomes one-third full.
When there is approximately 1MB of changed records in the buffer.
This total does not include deleted or inserted records.
1。各位有何看法?
2。10G的LGWR什么时候写redo log buffer 到 online redo log files?