察看当前数据库被锁的对象

21.察看当前数据库被锁的对象

 

SELECT AO.OBJECT_NAME,

      AO.OBJECT_TYPE,

      SESS.SID,

      SESS.SERIAL#,

       SESS.STATUS,

      SESS.SQL_ID,

      LO.ORACLE_USERNAME,

      LO.OS_USER_NAME,

      LO.LOCKED_MODE,

      A.SQL_FULLTEXT,

      A.DISK_READS,

      A.BUFFER_GETS,

      A.OPTIMIZER_MODE,

      A.ROWS_PROCESSED,

      A.EXECUTIONS,

       A.LAST_ACTIVE_TIME,

      A.CPU_TIME / 1000000,

      SESS.BLOCKING_SESSION_STATUS,

      SESS.BLOCKING_INSTANCE,

      SESS.BLOCKING_SESSION,

      SESS.EVENT#,

      SESS.EVENT,

      SESS.PROGRAM,

      SESS.MODULE,

      SESS.ACTION,

      SESS.MACHINE

  FROM V$LOCKED_OBJECT LO

INNER JOIN DBA_OBJECTS AO

    ON AO.OBJECT_ID =LO.OBJECT_ID

INNER JOIN V$SESSION SESS

    ON LO.SESSION_ID =SESS.SID

  LEFT JOIN V$SQLAREA A

    ON SESS.SQL_ID =A.SQL_ID;