select
  NAME,                                    -- NAME VARCHAR2(4)
  NETWORK,                                 -- NETWORK VARCHAR2(1024)
  PADDR,                                   -- PADDR RAW(8)
  STATUS,                                  -- STATUS VARCHAR2(16)
  ACCEPT,                                  -- ACCEPT VARCHAR2(3)
  MESSAGES,                                -- MESSAGES NUMBER
  BYTES,                                   -- BYTES NUMBER
  BREAKS,                                  -- BREAKS NUMBER
  OWNED,                                   -- OWNED NUMBER
  CREATED,                                 -- CREATED NUMBER
  IDLE,                                    -- IDLE NUMBER
  BUSY,                                    -- BUSY NUMBER
  LISTENER,                                -- LISTENER NUMBER
  CONF_INDX                                -- CONF_INDX NUMBER
from
  GV$DISPATCHER
where
  inst_id = USERENV('Instance')