DML Locks Automatically Acquired for DML Statements (349)
The previous sections explained the different types of data locks, the modes in which
they can be held, when they can be obtained, when they are obtained, and what they
prohibit. The following sections summarize how Oracle automatically locks data on
behalf of different DML operations.
執行DML語句時自動獲得的DML鎖, 獲取的行鎖和表鎖見下表
Locks Obtained By DML Statements
DML Statement Row Locks? Mode of Table Lock
SELECT ... FROM table
INSERT INTO table ... X RX
UPDATE table ... X RX
DELETE FROM table ... X RX
SELECT...FROM table ...FOR UPDATE OF X RS
LOCK TABLE table IN ...
ROW SHARE MODE RS
ROW EXCLUSIVE MODE RX
SHARE MODE S
SHARE EXCLUSIVE MODE SRX
EXCLUSIVE MODE X
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-991299/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 學習Join View-Key-Preserved Tables以及DML Statements on a join viewView
- DML_LOCKS設定為0導致SHUTDOWN IMMEDIATE失敗
- mongodb dmlMongoDB
- DML ViewsView
- Parallel DMLParallel
- Oracle Parallel DMLOracleParallel
- Oracle分批提交DMLOracle
- MySQL DML語句MySql
- alter session enable parallel dml 使DML語句並行執行SessionParallel並行
- DML、DDL、DCL區別
- 轉載--oracle DML鎖Oracle
- 淺談DML阻塞(上)
- 淺談DML阻塞(下)
- DDL,DML,DCL區別
- 關於主外來鍵關係DML父表和DML子表加鎖方式
- OGG 簡單DML同步
- DML操作 DDL觸發器觸發器
- Oracle DML NOLOGGINGOracle
- dml操作重做日誌分析
- ORACLE DML鎖定機制Oracle
- DBMS_ADVANCED_REWRITE and DML
- db2_dml鎖分析DB2
- oracle dml與索引index(一)Oracle索引Index
- MySQL DML運算元據MySql
- DDL、DML、DCL、DQL相關操作
- 入門MySQL——DML語句篇MySql
- SQL學習___03:DML語法SQL
- Sysbench-0.5改成只有DML操作
- MySQL基礎之DML語句MySql
- 使用for迴圈操作DML語句
- DML 語句處理過程
- GoldenGate單向表DML同步Go
- Mysql 基礎操作 DDL DML DCLMySql
- DML操作引起的blocking(一)BloC
- DML操作引起的blocking(二)BloC
- 閃回 錯誤的DML 操作
- 從底向上瞭解DML操作
- GoldenGate同步DML功能測試Go