select b.owner,b.object_name,l.session_id,l.locked_mode,l.OS_USER_NAME from v$locked_object l, dba_objects b where b.object_id=l.object_id;
查看连接的进程
SELECT sid, serial#, username, osuser FROM v$session;
杀掉进程
alter system kill session 'sid,serial#';