V$LOCKED_OBJECT definition in Oracle Database 11.2

V$LOCKED_OBJECT

select
  xidusn,                                  -- XIDUSN NUMBER
  xidslot,                                 -- XIDSLOT NUMBER
  xidsqn,                                  -- XIDSQN NUMBER
  object_id,                               -- OBJECT_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  oracle_username,                         -- ORACLE_USERNAME VARCHAR2(30)
  os_user_name,                            -- OS_USER_NAME VARCHAR2(30)
  process,                                 -- PROCESS VARCHAR2(24)
  locked_mode                              -- LOCKED_MODE NUMBER
from
  gv$locked_object
where
  inst_id = USERENV('Instance')

home | up