//查询死锁      select sess.sid,         sess.serial#,         lo.oracle_username,         lo.os_user_name,         ao.object_name,         lo.locked_mode         from v$locked_object lo,         dba_objects ao,         v$session sess      where ao.object_id = lo.object_id and lo.session_id = sess.sid;             //杀死进程      alter system kill session 'SID,SERIAL#';