Re: What is this Session Doing

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 Sep 2004 11:29:03 +0100

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

Other related posts: