[askdba] Re: What is the Process Doing
- From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 06:36:29 -0500
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:
