oracle 锁

CREATE OR REPLACE FORCE VIEW V_LOCK
(
   SESSION_ID,
   SERIAL#,
   LOCKED_MODE,
   ORACLE_USERNAME,
   OS_USER_NAME,
   MACHINE,
   TERMINAL,
   OBJECT_NAME,
   LOGON_TIME,
   SQL_ID,
   SQL_HASH_VALUE
)
AS
   SELECT l.session_id,
          e.serial#,
          l.locked_mode,
          l.oracle_username,
          l.os_user_name,
          e.machine,
          e.terminal,
          o.object_name,
          e.logon_time,
          e.SQL_ID,
          e.sql_hash_value
     FROM v$locked_object l, all_objects o, v$session e
    WHERE l.object_id = o.object_id
 　　AND l.session_id = e.sid
 ORDER BY sid, e.serial#;