查看是否存在死锁并解决死锁

--查看

Select s.username, l.object_id, l.session_id, s.serial#, s.lockwait, s.status, s.machine, s.program from v$session s, v$locked_object l where s.sid = l.session_id; Select s.username, l.object_i