Asynchronous Commit
參見:metalink 336219.1
10g可以非同步COMMIT了,應該可以優化相關的COMMIT相關的等待問題
該特性可以在SESSION或者SYSTEM級通過commit_write設定
或者是針對某個事物執行:
COMMIT WRITE BATCH NOWAIT
不過注意該特性是影響ACID中的Durability,資料在不是COMMIT就保證不在丟失的
還有,該引數在RAC環境中,可以分例項設定,最好是設定一樣
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8242091/viewspace-592668/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 非同步提交(Asynchronous COMMIT)非同步MIT
- 【oracle 10g R2 新特性】Asynchronous CommitOracle 10gMIT
- 非同步模式(Asynchronous)非同步模式
- Simple FSM 3(asynchronous reset)
- ID3d11asynchronous3D
- Simple FSM1(asynchronous reset)
- Simple FSM2(asynchronous reset)
- asynchronous i/o (aio) on HP-UXAIUX
- Dynamics CRM Asynchronous Service Performance: Code ManiaORM
- Taming the asynchronous beast with ES7AST
- git commit後如何取消commitGitMIT
- on commit delete rows and on commit preserve rowsMITdelete
- CommitMIT
- eclipse svn commit 報錯 Commit blocked by pre-commit hookEclipseMITBloCHook
- 非同步 PHP:為什麼? ( Asynchronous PHP: Why?)非同步PHP
- Chapter2:Asynchronous Control Flow PatternsAPT
- HP-UX: Asynchronous i/o (Doc ID 139272.1)UX
- HOW TO CHECK IF ASYNCHRONOUS I/O IS WORKING ON LINUXLinux
- Git commit 之後,想撤銷 commitGitMIT
- svn commitMIT
- SOLARIS: Asynchronous I/O (AIO) on Solaris (SPARC) servers_48769.1AIServer
- commit 與do_key('commit_form')區別MITORM
- git commit --amendGitMIT
- AWS Code CommitMIT
- commit 衝突MIT
- commit_writeMIT
- Load a script file in sencha, supports both asynchronous and synchronous approachesAPP
- Asynchronous I/O Support On Windows (Doc ID 1228845.1)Windows
- 【xiaotie】Asp.Net異常Asynchronous 的解決方案ASP.NET
- git commit 彈出編輯器後報錯: Aborting commit due to empty commit message.GitMIT
- 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