查询锁表进程(直接运行下列代码)
select b.username,b.sid,b.serial#,logon_time
from v$locked_object a,v$session b
where a.session_id = b.sid order by b.logon_time;
杀死会话
alter system kill session 'sid,serial#';
'sid'和'serial#'是查询锁表进程相对应查出来的字段
如果有ora-00031错误,则在后面加immediate;