Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow response when connecting via LISTENER vs. Bequeth - any ideas?
You need to look at your network. The listener only plays a small part in
the client connection and only at the start. When a client connects for the
first time, the listener receives the request on port 1521 (default). Next
the listener spawns a dedicated server process for the client, and gives the
connection over to that process which establishes its own connection with
the client. The listener is out of the picture after this happens.
The slow part of the listener process (on UNIX) is creating the dedicated server process. Returning data from queries does not involve the listener. In fact, if you terminate the listener process, all existing connections are unaffected (only new connections will be prevented). Received on Wed Sep 05 2001 - 01:44:08 CDT