/*死锁查询-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