Re: why does my session wait on 'execute reply' ?

From: utkanbir <hopehope_123_at_yahoo.com>
Date: 26 Jan 2004 01:01:17 -0800
Message-ID: <f6c90ebe.0401260006.4e39b914@posting.google.com>

Thank you very much for your mail.

KInd Regards,
hope

Stephan Bressler <sbresslerx_no_spam_at_arcor.de> wrote in message news:<bur30f$lth$1_at_news.mch.sbs.de>...
> 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 Mon Jan 26 2004 - 03:01:17 CST