Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why does my session wait on 'execute reply' ?
snip
> 165 47695 PX Deq: Execute
> Reply sleeptime/senderid 200 00000000000000C8 passes 2 0000000000000002 0 00 0 0 WAITING
this is a parallel query wait event. You should see pq slaves executing.
Run
select * from v$px_session where qcsid=<your waiting session>
Stephan Received on Fri Jan 23 2004 - 06:11:06 CST