Tuesday, December 22, 2009

V$DISPATCHER_CONFIG

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


V$DISPATCHER_CONFIG displays information about the dispatcher configurations and their attributes.
Column
Datatype
Description
CONF_INDX
NUMBER
Zero-based index of the DISPATCHERS configuration
NETWORK
VARCHAR2(128)
Network protocol or listening address of dispatchers (may be truncated)
DISPATCHERS
NUMBER
Number of dispatchers to maintain for the configuration
CONNECTIONS
NUMBER
Maximum number of concurrent connections per dispatcher
SESSIONS
NUMBER
Maximum number of concurrent sessions per dispatcher
POOL
VARCHAR2(4)
Indicates whether Connection Pooling is on:
  • IN
  • OUT
  • BOTH
  • OFF
TICKS
NUMBER
Tick size (in seconds) for Connection Pooling timeout
INBD_TIMOUT
NUMBER
Timeout duration (in ticks) for pooled inbound connections
OUTBD_TIMOUT
NUMBER
Timeout duration (in ticks) for pooled outbound connections
MULTIPLEX
VARCHAR2(4)
Indicates whether Session Multiplexing is on:
  • IN
  • OUT
  • BOTH
  • OFF
LISTENER
VARCHAR2(1200)
Listeners to register dispatchers with (may be truncated)
SERVICE
VARCHAR2(128)
Service names supported (may be truncated)

Oracle data dictionary views

Last updated: 2009-12-22 Tuesday

No comments:

Post a Comment