user commit (118)
When a user commits a transaction, the transaction is assigned a system change
number (SCN), which Oracle records along with the transaction’s redo entries in the
redo log. SCNs are recorded in the redo log so that recovery operations can be
synchronized in Real Application Clusters and distributed databases.
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.
當使用者提交一個事務時 , 將被記錄一個SCN , 同樣也記錄在重做日誌檔案中 .
當系統處於高數位活動量時 , LGWR可以使用名為組提交的機制來減少磁碟I/O .
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-979921/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Git批量修改歷史commit中的user.name 和user.emailGitMITAI
- zt:Oracle10gR2中調整user commit的實用方法OracleMIT
- AWR報告裡的log file sync和user commit為什麼不相等?MIT
- 在Oracle10gR2中調整過於頻繁user commit的一個方法OracleMIT
- git commit後如何取消commitGitMIT
- on commit delete rows and on commit preserve rowsMITdelete
- CommitMIT
- eclipse svn commit 報錯 Commit blocked by pre-commit hookEclipseMITBloCHook
- oracle ocp 052-118Oracle
- Git commit 之後,想撤銷 commitGitMIT
- svn commitMIT
- Asynchronous CommitMIT
- UNDO_MANAGEMENT Initialization Parameter (118)
- commit 與do_key('commit_form')區別MITORM
- 開始-執行-命令大全118
- CF118E Bertown roads
- git commit --amendGitMIT
- AWS Code CommitMIT
- commit 衝突MIT
- commit_writeMIT
- git commit 彈出編輯器後報錯: Aborting commit due to empty commit message.GitMIT
- oracle user$Oracle
- commit_write,commit_logging,commit_wait引數和oracle redo行為MITAIOracle Redo
- 關於Git commitGitMIT
- Git拆分commit提交GitMIT
- 修改 commit messageMIT
- 增強的 COMMITMIT
- oracle之commit控制OracleMIT
- commit做了什麼?MIT
- 關於oracle commitOracleMIT
- 物化檢視 on commitMIT
- Commit Transactions (143)MIT
- git commit 規範GitMIT
- Git commit規範GitMIT
- git 修改 commit 資訊GitMIT
- 【Oracle】-【隱式commit】-正常與異常退出對commit的作用OracleMIT
- [絕對原創] SAP Get User data by User ID
- Connection to x as user y failed: ERROR: Wrong password for userAIError