Modes of Locking (334)
Oracle uses two modes of locking in a multiuser database:
■ Exclusive lock mode prevents the associates resource from being shared. This lock
mode is obtained to modify data. The first transaction to lock a resource
exclusively is the only transaction that can alter the resource until the exclusive
lock is released.
■ Share lock mode allows the associated resource to be shared, depending on the
operations involved. Multiple users reading data can share the data, holding share
locks to prevent concurrent access by a writer (who needs an exclusive lock).
Several transactions can acquire share locks on the same resource.
鎖的型別
1. 排他鎖 : 阻止被鎖定的資源共享. 對資料進行修改時,需要或得這種鎖.第一個排他地對資源加
鎖的事物是唯一可以對此資源進行修改的事物,直至排他鎖被釋放
2. 共享鎖 : 根據操作型別 , 允許被鎖定的資源共享 . 多個事務可對相同的資源加共享鎖
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-990396/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 334
- 睿爸334
- drools中Fact的equality modes
- 6 Oracle Data Guard Protection Modes 保護模式Oracle模式
- How Oracle Locking WorksOracle
- Uncowed Forces Codeforces Round #334
- 淺談mysql innodb lockingMySql
- Explicit (Manual) Data Locking (364)
- UDI-00010: multiple job modes requested, schema and tables
- 【LeetCode】Increasing Triplet Subsequence(334)LeetCode
- REFERENTIAL INTEGRITY AND LOCKING [ID 33453.1]
- Overview of Locking Mechanisms (310)View
- MySQL 5.5 -- Metadata Locking Within TransactionsMySql
- 如何查詢 library locking 問題
- Mysql next-locking 間隙鎖MySql
- Oracle 11G OCP 1Z0-053 334Oracle
- /usr/bin/xauth: error in locking authority file錯誤Error
- Default Locking for INSERT, UPDATE, DELETE, and SELECT ... FOR UPDATE (351)delete
- PostgreSQL 原始碼解讀(223)- Locks(Fast Path Locking)SQL原始碼AST
- MySQL innodb 的間隙鎖定(next-key locking)MySql
- MySQL 8.0 Reference Manual(讀書筆記63節--InnoDB Locking)MySql筆記
- PostgreSQL 原始碼解讀(222)- Locks(Lock Manager Internal Locking)SQL原始碼
- singleton模式的一種變體:double-checked locking (轉)模式
- Script to Check for Foreign Key Locking Issues [ID 1019527.6]
- ES叢集搭建問題:memory locking requested for elasticsearch process but memory is not lockedElasticsearch
- 邦民:日本中年人遊戲氪金報告出爐 人均334元遊戲
- 【微信公眾號】【深入解析】DRM和read-mostly locking
- Oracle Database Transactions and Locking Revealed.pdf 英文原版 免費下載OracleDatabase
- Linux記憶體子系統——Locking Pages(記憶體鎖定)Linux記憶體
- Oradebug使用淺談--生成Hang或Locking問題分析檔案
- MySQL 8.0 Reference Manual(讀書筆記66節--locking read 與lock)MySql筆記
- LOGMINER當前日誌出現ORA-310和ORA-334錯誤
- MySQL 8.0 Reference Manual(讀書筆記59節-- Buffering and Caching 和 Locking)MySql筆記
- 記錄-cubemx配置STM32F334雙ADC+DMA同步規則轉換
- STM32F334用keil5的debug除錯時出現問題除錯
- 比亞迪:2023年比亞迪汽車銷售302萬輛 全年出口同比增長334%
- FAQ: Detecting and Resolving Locking Conflicts and Ora-00060 errors [ID 15476.1]Error
- MySQL 透過 Next-Key Locking 技術(行鎖+間隙鎖)避免幻讀問題MySql