Kurian, If you read my post u will find that i have mentioned that the session is not waiting for anything and it is gobbing CPU ... :) ~ Ganesh On Fri, 24 Sep 2004 17:24:08 +0530, Kurian Abraham <kzabraham@xxxxxxxxxx> wrote: > Look at v$session_wait... see what is the session waiting for !!! > > -----Original Message----- > From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] > On Behalf Of Subodh Deshpande > Sent: Friday, September 24, 2004 5:06 PM > To: askdba@xxxxxxxxxxxxx > Subject: [askdba] Re: What is the Process Doing > > 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. > >=20 > > Solaris 64 Bit 9.2.0.5 > >=20 > > Thanks. > >=20 > >=20 > > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja > <ganesh.raja@xxxxxxxxx> wrote: > > > Hi, > > >=20 > > > 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] > > >=20 > > > 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. > > >=20 > > > The weird thing is that that the CPU statistics for this process are > > > not being updated on v$sessstat > > >=20 > > > Any help is greatly appreciated. > > >=20 > > > Cheers > > > Ganesh R > > > > >=20 > > Good Luck..Subodh Deshpande > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Experience Is Knowledge > Wisdom Is Philosophy > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > --=20 > _______________________________________________ > 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=3Dlycos10 > >