/*死锁查询-1*/
SELECT o.object_name,
l.session_id,l.process,
l.locked_mode FROM v$locked_object l ,
dba_objects o WHERE
o.object_id=l.object_id
------------------------------------------------
/*死锁查询-2*/
select GL.SESSION_ID,
do.object_name,
GL.PROCESS,
GL.LOCKED_MODE,
GL.ORACLE_USERNAME,
GL.PROCESS
from gv$locked_object
GL,
DBA_OBJECTS DO
WHERE GL.OBJECT_ID =
DO.object_id
order
by
do.object_name