查找到数据库中所有的DML语句产生的锁，还可以发现，任何DML语句其实产生了两个锁，一个是表锁，一个是行锁：
SELECT
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 vsession s, vlock l, dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT Null
杀锁命令：
alter system kill session ‘sid,serial#’；
alter system kill session’50,492’;（其中’50,492’为上面查出来的’sid,serial#’）
–以下几个为相关表
SELECT * FROM vlock;
SELECT * FROM vsqlarea;
SELECT * FROM vsession;
SELECT * FROM vprocess ;
SELECT * FROM vlocked_object;
SELECT * FROM all_objects;
SELECT * FROM vsession_wait;
1.查出锁定object的session的信息以及被锁定的object名：
SELECT l.session_id sid,
s.serial#,
l.locked_mode,
l.oracle_username,
l.os_user_name,
s.machine,
s.terminal,
o.object_name,
s.logon_time
FROM vlocked_object l, all_objects o, vsession s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
ORDER BY sid, s.serial#;
2.查出锁定表的session的sid, serial#,os_user_name, machine name, terminal和执行的语句，比上面那段多出sql_text和action：
SELECT l.session_id sid,
s.serial#,
l.locked_mode,
l.oracle_username,
s.user#,
l.os_user_name,
s.machine,
s.terminal,
a.sql_text,
a.action
FROM vsqlarea a, vsession s, vlocked_object l
WHERE l.session_id = s.sid
AND s.prev_sql_addr = a.address
ORDER BY sid, s.serial#;
3.查出锁定表的sid, serial#,os_user_name, machine_name, terminal，锁的type,mode：
SELECT s.sid,
s.serial#,
s.username,
s.schemaname,
s.osuser,
s.process,
s.machine,
s.terminal,
s.logon_time,
l.type
FROM vsession s, v$lock l
WHERE s.sid = l.sid
AND s.username IS NOT NULL
ORDER BY sid;