LGWR group commits(原)

funnyok發表於2007-07-10
LGWR group comments the transactions when there are more than one transactions commited while the previous commition processed.[@more@]In times of high activity, LGWR can write to the redo log file using group commits. For example, assume that a user commits a transaction. LGWR must write the transaction's redo entries to disk, and as this happens, other users issue COMMIT statements. However, LGWR cannot write to the redo log file to commit these transactions until it has completed its previous write operation. After the first transaction's entries are written to the redo log file, the entire list of redo entries of waiting transactions (not yet committed) can be written to disk in one operation, requiring less I/O than do transaction entries handled individually. Therefore, Oracle minimizes disk I/O and maximizes performance of LGWR. If requests to commit continue at a high rate, then every write (by LGWR) from the redo log buffer can contain multiple commit records.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/3137/viewspace-925742/,如需轉載,請註明出處,否則將追究法律責任。

相關文章