首页 > 数据库 > Oracle > Oracle Lock Management Services (365)

Oracle Lock Management Services (365)

原创 Oracle 作者:tsinglee 时间:2007-12-13 10:28:28 0 删除 编辑

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

1. 利用 Oracle 锁管理服务可以在 PL/SQL 块中使用以下语句 :
a. 获取特定类型的锁
b. 给锁取一个可识别的唯一名字
c. 改变锁的类型
d. 释放锁
2. 用户锁具备Oracle锁的功能(包括死锁检测) . 用户锁不会与Oracle锁冲突 ,
因为用户锁的名称使用前缀 UL.
3. 可通过DBMS_LOCK包使用 Oracle 的锁管理服务


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量