Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Distributed Oracle Data Warehouses MANAGING THE LISTENER PROCESS

As mentioned earlier, the listener is a software program that runs on each remote node that listens for incoming database requests. When a request is detected, the listener may direct the request to any of the following:

* A dedicated server

* A multithreaded server

* An existing process or pre-spawned shadow

Note that the configuration of an Oracle listener is a direct result of the parameters specified in the startup deck for the Oracle database. This parameter file, called init.ora, contains the following parameters to define the multithreaded server and listener.

# -----------------------
# Multithreaded Server
# -----------------------

MTS_DISPATCHERS = "tcp,3"

MTS_LISTENER_ADDRESS = "(ADDRESS=(PROTOCOL=tcp) (HOST=seagull)
(PORT=1521))"

MTS_MAX_DISPATCHERS = 5

MTS_MAX_SERVERS = 20

# ---------------------------
# Distributed systems options
# ---------------------------

DISTRIBUTED_LOCK_TIMEOUT = 60

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME = 200

DISTRIBUTED_TRANSACTIONS = 6

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.