Re: parallel query server stays on hp for killed processes

From: A.E.Vervaeke <alanv_at_opustel.com>
Date: 1998/02/19
Message-ID: <6chlov$jvk@news9.noc.netcom.net>#1/1

Parallel Query servers P001, P002, etc... stay around for awhile after a client process is killed. By setting the PARALLEL_SERVER_IDLE_TIME parameter in the INIT.ORA to 0, the process should die immediately. But then, it just takes that much more system resource when it becomes necessary to start up another one. Your call.

Alan V

Thomas Hilke wrote in message <34EC2A0B.7A44C536_at_dlh.de>...
>hi.
>
>I've trouble with the parallel query servers on a hp ux 10.20 with
>oracle 7.3.3.4.
>When a client-session (on NT 4.0 Workstation) is killed, or the client
>crashed, then
>are the pq-servers on the hp still active.
>
>This has the effect that the DB slow down dramatically
>
>
>have anyone an idee ?
>
>
>
Received on Thu Feb 19 1998 - 00:00:00 CST