Oracle Lock Management Services (365)
With Oracle Lock Management services, an application developer can include
statements in PL/SQL blocks that:
■ Request a lock of a specific type
■ Give the lock a unique name recognizable in another procedure in the same or in
another instance
■ Change the lock type
■ Release the lock
Because a reserved user lock is the same as an Oracle lock, it has all the Oracle lock
functionality including deadlock detection. User locks never conflict with Oracle locks,
because they are identified with the prefix UL.
The Oracle Lock Management services are available through procedures in the DBMS_LOCK
package.
Oracle鎖管理服務
1. 利用 Oracle 鎖管理服務可以在 PL/SQL 塊中使用以下語句 :
a. 獲取特定型別的鎖
b. 給鎖取一個可識別的唯一名字
c. 改變鎖的型別
d. 釋放鎖
2. 使用者鎖具備Oracle鎖的功能(包括死鎖檢測) . 使用者鎖不會與Oracle鎖衝突 ,
因為使用者鎖的名稱使用字首 UL.
3. 可透過DBMS_LOCK包使用 Oracle 的鎖管理服務
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-992630/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle segment space management and extent management幾則Oracle
- Oracle Cluster Time ManagementOracle
- 漫談Oracle RAC servicesOracle
- Overview of Oracle Net Services (280)ViewOracle
- oracle lock鎖_v$lock_轉Oracle
- Oracle Management Server Could Not Be StartedOracleServer
- Oracle-Segment space managementOracle
- [Oracle Script] LockOracle
- About Oracle LockOracle
- oracle enqueue lockOracleENQ
- Oracle Latch & LockOracle
- Oracle Application Management Pack and Application Change Management Pack for Oracle E-Business SuitOracleAPPUI
- How Oracle Net Services Works (281)Oracle
- Oracle Shared Pool Memory ManagementOracle
- Oracle Automatic PGA Memory ManagementOracle
- 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 19c Database Management ToolsOracleDatabase
- Oracle DRM 簡介(Dynamic Resource management)Oracle
- Oracle Memory Management and HugePage (連載一)Oracle
- Oracle Memory Management and HugePage (連載二)Oracle
- Oracle Memory Management and HugePage (連載三)Oracle
- Oracle Memory Structure 1. Overview And ManagementOracleStructView
- oracle v$lock詳解Oracle
- [Oracle Script] check lock infoOracle
- Oracle 之pin和lockOracle
- 討論 Oracle RAC services之神奇作用Oracle
- 【Services】Oracle 11g RAC使用Manual和Policy Managed方法配置和使用ServicesOracle
- Tablespace Management Enhancements in Oracle Database 10gOracleDatabase
- oracle11g memory management系列(一)Oracle
- oracle dead lock與效能Oracle
- oracle使用者被lockOracle
- oracle v$lock系列之三Oracle