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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/3137/viewspace-925742/