PX Slaves won't die

From: <bryan_w_taylor_at_my-deja.com>
Date: Fri, 03 Nov 2000 00:45:48 GMT
Message-ID: <8tt1rr$57m$1@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 Thu Nov 02 2000 - 18:45:48 CST