A session can be inactive and still
hold open cursors. It is possible
that the cursor that caused the slaves
to go active is still open.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison Wesley Longman
Book bound date now 1st Dec 2000
bryan_w_taylor_at_my-deja.com wrote in message <8tt1rr$57m$1_at_nnrp1.deja.com>...
>RedHat 6.1 Oracle 8.1.5.0.2
>
>My parallel execution slaves don't seem to want to die, even though I
>have parallel_min_servers = 0.
>
>When I query v$px_process , it shows P001-P004 have status "In use".
>But they don't seem to use any CPU time when I run top. Moreover, when
>I look up their query coordinater master session in v$px_session and
>then v$sessions I find that the parent sid shows "inactive" status.
>
>Several hours later everything is unchanged. I ran all queries from a
>separate account.
>
>What can I do? How do I kill my undead zombie slaves?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Nov 05 2000 - 06:37:48 CST
