V$DISPATCHER_CONFIG definition in Oracle Database 11.2
V$DISPATCHER_CONFIG

select
  conf_indx,                               -- CONF_INDX NUMBER
  network,                                 -- NETWORK VARCHAR2(1024)
  dispatchers,                             -- DISPATCHERS NUMBER
  connections,                             -- CONNECTIONS NUMBER
  sessions,                                -- SESSIONS NUMBER
  pool,                                    -- POOL VARCHAR2(4)
  ticks,                                   -- TICKS NUMBER
  inbd_timout,                             -- INBD_TIMOUT NUMBER
  outbd_timout,                            -- OUTBD_TIMOUT NUMBER
  multiplex,                               -- MULTIPLEX VARCHAR2(4)
  listener,                                -- LISTENER VARCHAR2(1200)
  service                                  -- SERVICE VARCHAR2(512)
from
  GV$DISPATCHER_CONFIG
where
  inst_id = USERENV('Instance')

home |  up