Sorry here are the versions. Solaris 64 Bit 9.2.0.5 Thanks. On Fri, 24 Sep 2004 11:28:12 +0100, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote: > 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 > -- //www.freelists.org/webpage/oracle-l