Home >Database >Mysql Tutorial >查看哪些对象被lock

查看哪些对象被lock

WBOYOriginal: 2016-06-07 14:55:111415browse

Oracle数据库无 SELECT /*+ rule */ s.username, DECODE (l.TYPE, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL ) lock_level, o.owner, o.object_name, o.object_type, s.SID, s.serial#, s.terminal, s.machine, s.program, s.osuser FROM v$session s, v$

Oracle数据库

SELECT /*+ rule */
       s.username,
       DECODE (l.TYPE,
               'TM', 'TABLE LOCK',
               'TX', 'ROW LOCK',
               NULL
              ) lock_level, o.owner, o.object_name, o.object_type, s.SID,
       s.serial#, s.terminal, s.machine, s.program, s.osuser
  FROM v$session s, v$lock l, dba_objects o
 WHERE l.SID = s.SID AND l.id1 = o.object_id(+) AND s.username IS NOT NULL

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：在 SQL Server 中获取客户端连接的 IP 地址Next article：oracle 创建job 语句

See more

查看哪些对象被lock

Related articles