用如下语句查询锁死的表：

selectp.spid,
a.serial#,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
fromv$processp,v$sessiona,v$locked_objectb,all_objectsc
wherep.addr=a.paddr
anda.process=b.process
andc.object_id=b.object_id;
查询出被锁表：

表解锁

alter system kill session 'sid,serial#';

alter system kill session '584,2178';