查询oracle数据库是否锁表

SELECT /*+ rule */

ername as username,

decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,ctime 耗时, o.owner as owner,

o.object_name as 锁表名称,

o.object_type as object_type,

s.sid,

s.serial#,

s.terminal as terminal,

s.machine as 机器名称,

s.program 程序名称,

s.osuser,

'alter system kill session '|| '''' || l.SID || ',' ||SERIAL#|| ''';' 杀表语句,

sql_text 锁表语句

FROM v$session s, v$lock l, dba_objects o,v$sqltext t

WHERE l.sid = s.sid

AND l.id1 = o.object_id(+)

AND ername is NOT Null

and s.status='ACTIVE' and ( l.type='TM' OR l.type='TX')

and s.sql_hash_value=t.HASH_VALUE

order by ctime desc