原理为查找锁表用户,然后注销掉即可,以下SQL很有帮助:
select * from v$locked_object
select * from v$locked_object
select * from v$session where sid = '45'
alter system kill session '45,494'
SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,
s.terminal, s.logon_time, l.type
FROM v$session s, v$lock l
WHERE s.sid = l.sid
AND s.username IS NOT NULL
ORDER BY sid
SELECT p.spid, a.serial#,a.program, c.object_name, b.session_id, b.oracle_username,
b.os_user_name ,a.logon_time
FROM v$process p, v$session a, v$locked_object b, all_objects c
WHERE p.addr = a.paddr AND a.process = b.process
AND c.object_id = b.object_id