Re: Shared Server Configuration: When exactly is the connect to the dispatcher established?

On 31 Aug 2004 06:33:56 -0700, cha_at_christian-hartmann.de (Christian Hartmann) wrote:

>Hi there,
>
>I've got a simple question regarding a Shared Server Configuration:
>When exactly does a client connect to a dispatcher. Only during the
>connect phase or every time a request or even a transaction is
>started.
>
>Or, in other words: Is a connection of a client to a dispatcher solid
>as long as the conenction of the client exist?
>
>Regards,
>
>Christian

If you think logically it is.
Listener hands off to dispatcher, and there is no reason why the connection should be established over and over again. The dispatcher however can and will hand off sql requests to different shared server session.

--
Sybrand Bakker, Senior Oracle DBA