V$QUEUE definition in Oracle Database 11.2
V$QUEUE

select
  PADDR,                                   -- PADDR RAW(8)
  TYPE,                                    -- TYPE VARCHAR2(10)
  QUEUED,                                  -- QUEUED NUMBER
  WAIT,                                    -- WAIT NUMBER
  TOTALQ                                   -- TOTALQ NUMBER
from
  GV$QUEUE
where
  inst_id = USERENV('Instance')

home |  up