V$GES_BLOCKING_ENQUEUE definition in Oracle Database 11.2
V$GES_BLOCKING_ENQUEUE

select
  HANDLE,                                  -- HANDLE RAW(8)
  GRANT_LEVEL,                             -- GRANT_LEVEL VARCHAR2(9)
  REQUEST_LEVEL,                           -- REQUEST_LEVEL VARCHAR2(9)
  RESOURCE_NAME1,                          -- RESOURCE_NAME1 VARCHAR2(30)
  RESOURCE_NAME2,                          -- RESOURCE_NAME2 VARCHAR2(30)
  PID,                                     -- PID NUMBER
  TRANSACTION_ID0,                         -- TRANSACTION_ID0 NUMBER
  TRANSACTION_ID1,                         -- TRANSACTION_ID1 NUMBER
  GROUP_ID,                                -- GROUP_ID NUMBER
  OPEN_OPT_DEADLOCK,                       -- OPEN_OPT_DEADLOCK NUMBER
  OPEN_OPT_PERSISTENT,                     -- OPEN_OPT_PERSISTENT NUMBER
  OPEN_OPT_PROCESS_OWNED,                  -- OPEN_OPT_PROCESS_OWNED NUMBER
  OPEN_OPT_NO_XID,                         -- OPEN_OPT_NO_XID NUMBER
  CONVERT_OPT_GETVALUE,                    -- CONVERT_OPT_GETVALUE NUMBER
  CONVERT_OPT_PUTVALUE,                    -- CONVERT_OPT_PUTVALUE NUMBER
  CONVERT_OPT_NOVALUE,                     -- CONVERT_OPT_NOVALUE NUMBER
  CONVERT_OPT_DUBVALUE,                    -- CONVERT_OPT_DUBVALUE NUMBER
  CONVERT_OPT_NOQUEUE,                     -- CONVERT_OPT_NOQUEUE NUMBER
  CONVERT_OPT_EXPRESS,                     -- CONVERT_OPT_EXPRESS NUMBER
  CONVERT_OPT_NODEADLOCKWAIT,              -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
  CONVERT_OPT_NODEADLOCKBLOCK,             -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
  WHICH_QUEUE,                             -- WHICH_QUEUE NUMBER
  STATE,                                   -- STATE VARCHAR2(64)
  AST_EVENT0,                              -- AST_EVENT0 NUMBER
  OWNER_NODE,                              -- OWNER_NODE NUMBER
  BLOCKED,                                 -- BLOCKED NUMBER
  BLOCKER                                  -- BLOCKER NUMBER
from
  GV$GES_BLOCKING_ENQUEUE
where
  INST_ID = USERENV('Instance')

home |  up