[askdba] Re: What is the Process Doing

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 24 Sep 2004 12:42:00 +0100

That does not answer My Question.. I would not be able to Kill a Slave
Process.. No the Session Active Kicking and Gobbing CPU.

Cheers
Ganesh 


On Fri, 24 Sep 2004 06:36:29 -0500, Subodh Deshpande
<subodh_deshpande@xxxxxxxxx> wrote:
> hi ganesh,
> 
> just a thought, what it is showing in v$session for that sid which you have 
> seen in v$sess_io..are they of same user..inactive..
> 
> if in v$session, its inactive or dead you can kill that sid and serial#..
> 
> 
> ----- Original Message -----
> From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
> Date: Fri, 24 Sep 2004 11:29:28 +0100
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Re: What is the Process Doing
> 
> > Sorry here are the versions.
> >
> > Solaris 64 Bit 9.2.0.5
> >
> > Thanks.
> >
> >
> > On Fri, 24 Sep 2004 11:27:32 +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
> > >
> >
> 
> 
> Good Luck..Subodh Deshpande
> 
> ===============================================
> Experience Is Knowledge
> Wisdom Is Philosophy
> ==============================================
> 
> --
> _______________________________________________
> Find what you are looking for with the Lycos Yellow Pages
> http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
> 
>

Other related posts: