ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 锁相关视图

oracle 锁相关视图

原创 Linux操作系统 作者:csdw81 时间:2012-03-16 10:46:32 0 删除 编辑
View Description
V$LOCK
Lists the locks currently held by Oracle Database and outstanding
requests for a lock or latch
DBA_BLOCKERS
Displays a session if it is holding a lock on an object for which
another session is waiting
DBA_WAITERS
Displays a session if it is waiting for a locked object
DBA_DDL_LOCKS
Lists all DDL locks held in the database and all outstanding
requests for a DDL lock
DBA_DML_LOCKS
Lists all DML locks held in the database and all outstanding
requests for a DML lock
DBA_LOCK
Lists all locks or latches held in the database and all outstanding
requests for a lock or latch
DBA_LOCK_INTERNAL
Displays a row for each lock or latch that is being held, and one
row for each outstanding request for a lock or latch

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16147313/viewspace-718719/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-12-07

  • 博文量
    5
  • 访问量
    11166