About Oracle Lock
1)A modified row is always locked exclusively so that other transactions cannot modify the row until the transaction holding the lock is committed or rolled back.
However, if the transaction dies due to instance failure, block-level recovery makes a row available before the entire transaction is recovered.
2)Oracle can roll back multiple transactions simultaneously as needed. All transactions systemwide that were active at the time of failure are marked as terminated. Instead of waiting for SMON to roll back terminated transactions, new transactions can recover blocking transactions themselves to get the row locks they need.
With fast-start fault recovery, the Oracle database is opened for access by applications without having to wait for the undo, or rollback, phase to be completed. The rollback of data locked by uncommitted transaction is done dynamically on an as needed basis. If the user process encounters a row locked by a crashed transaction, then it just rolls back that row. The impact of rolling back the rows requested by a query is negligible.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24104518/viewspace-715171/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- About Oracle WITH clauseOracle
- About Oracle HanganalyzeOracle
- About the Oracle GoldenGate TrailOracleGoAI
- about oracle10g racOracle
- About the Oracle Universal Installer Inventory!Oracle
- oracle lock鎖_v$lock_轉Oracle
- [Oracle Script] LockOracle
- oracle enqueue lockOracleENQ
- Oracle Latch & LockOracle
- about oracle10g rac(轉)Oracle
- the program list about oracle database in SAP systemOracleDatabase
- ORACLE LOCK,LATCH,PINOracle
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- Oracle Lock Information QueriesOracleORM
- Dead lock - oracleOracle
- ORACLE lock 轉貼Oracle
- ORACLE查LOCK表Oracle
- oracle lock系列一Oracle
- oracle v$lock詳解Oracle
- [Oracle Script] check lock infoOracle
- Oracle 之pin和lockOracle
- Oracle Lock Management Services (365)Oracle
- An interesting thread on Oracle-l about BBEDRESTthreadOracle
- oracle dead lock與效能Oracle
- oracle使用者被lockOracle
- oracle v$lock系列之三Oracle
- About HTMLHTML
- About interviewView
- About Personality
- About IndexDBIndex
- about bapiAPI
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- oracle全文索引之About_INDEX_THEMES操作Oracle索引Index
- oracle異常:library cache lockOracle
- Oracle如何查詢當前LockOracle
- oracle DBMS_LOCK.SLEEP()的使用Oracle
- Oracle裡面的user被lock了Oracle
- about datapump parallelParallel