RelationalDBDesign RelationalDBDesign


Network Config   «Prev  Next»
Lesson 5 MTS and incoming connections
Objective Describe how MTS processes incoming connections.

MTS and Incoming Connections

The listener is a software program that runs on each remote node and listens for any incoming database requests. When a request is detected, the listener may direct the request to:
  1. A dedicated server
  2. A multithreaded server
  3. An existing process or pre-spawned shadow process
The following Slideshow illustrates what happens if the listener chooses to direct that request to an MTS:


Oracle MTS Connections
When an Oracle database has been configured as a multi-threaded server, incoming connections are always routed to the dispatcher. However, a dedicated connection can be specifically requested by having SERVER=DEDICATED in the CONNECT_DATA portion of the connect descriptor. It is sometimes useful for transactions involving a high degree of activity to use a dedicated connection.
The next lesson discusses the architecture of MTS.

Sending MTS Request

Before moving on to the next lesson, click the Exercise link below to test your understanding of the processes involved in directing a request to MTS.
Sending MTS Request