alter system set dispatcher

A dispatcher is a process that enables many clients to connect to the same server without the need for a dedicated server process for each client. A dispatcher handles and directs multiple incoming network session requests to shared server processes. This is used when Shared Server configuration is enabled.

Load Balancing is a feature by which client connections are distributed evenly among multiple listeners, dispatchers, instances, and nodes so that no single component is overloaded. PMON is responsible for cleaning up the cache and freeing resources that the process was using. PMON also checks on dispatcher and server processes and restarts them if they have failed.

This load information enables the listener to determine which dispatcher can best handle a client connection request. If all dispatchers are blocked, the listener can spawn a dedicated server for the connection.

This wait is accounted when a session has issued a statement ALTER SYSTEM SET DISPATCHER = string and is waiting for the dispatchers to get started. Wait Time:

The session will wait 1 / 100 of a second and check to see if the new dispatchers have started; otherwise the session will wait again.