why does my session wait on 'execute reply' ?

Hi ,

I have a session which execute a select statement (joining two tables) ,
but since it started it seems it dis nothing.

This is the output of:
select * from v$session_wait where sid=165

165	47695	PX Deq: Execute
Reply	sleeptime/senderid	200	00000000000000C8	passes	2	0000000000000002		0	00	0	0	WAITING

and this is the output of:
select s.LOGON_TIME,s.SID,s.USERNAME,s.OSUSER,s.program,s.TYPE,sa.hash_value,sa.executions,sa.buffer_gets,sa.disk_reads, sa.rows_processed,sa.PARSE_CALLS
from v$sqlarea sa , v$session s
where s.SQL_HASH_VALUE = sa.HASH_VALUE and s.status='ACTIVE' and s.sid=165
order by sa.buffer_gets desc

1/23/2004 8:33:13 AM 165 TANIDWH tolgae TOAD.exe USER 4205024433 1 1433 0 0 1

The values are same for each run , it seems the session does nothing . What does execute reply mean? I hope to see some other parallel query slaves for this session but this is the only session , no other parallel query slaves i found. (may be i couldnt find them.)

Any help will be appreiated

Kind Regards,
hope Received on Fri Jan 23 2004 - 03:12:08 CST