查看Oracle lock

Oracle lock 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

Oracle lock

Oracle <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left本文来源gaodai#ma#com搞@代~码^网+:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;} .CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms

–> <!—ecms
• $velocityCount

–> <!—ecms

–>

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

喜欢 (0)赏

[搞代码]

分享 (0)