What is this Session Doing

Hi,

I have a query that has spawned parallel slaves. All the slaves are now waiting for a single slave to respond back. This slave process is churning away and eating up lot of CPU. [According to prstat]

When I see in v$sess_io i don't see any activity of this Process and since it is on the CPU it is not waiting .. So what is happening here.

The weird thing is that that the CPU statistics for this process are not being updated on v$sessstat

Any help is greatly appreciated.

Cheers
Ganesh R

--
http://www.freelists.org/webpage/oracle-l