死锁查看

SELECT object_name, machine, s.sid, s.serial#

FROM gv$locked_object l, dba_objects o, gv$session s

WHERE l.object_id = o.object_id

AND l.session_id = s.sid and object_name='SYS_IDENTITY';

alter system kill session '12, 31331';

select * from sys_identity for update;