afaik.. oradebug is not part of the Install. I am in a Client place and i need to involve the SE's to get me a Truss on the process.. So Just Trying to Avoid that !!!! ~ Ganesh On Fri, 24 Sep 2004 17:33:52 +0530, Kurian Abraham <kzabraham@xxxxxxxxxx> wrote: > Can u do a oradebug of that process id , which is CPU intensive ... > Do a oradebug for level 12, level 13 , then analyze the trace file for > more info. ... of the process > > Rg/- > Kurian > > -----Original Message----- > From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] > On Behalf Of Ganesh Raja > Sent: Friday, September 24, 2004 5:28 PM > To: askdba@xxxxxxxxxxxxx > Subject: [askdba] Re: What is the Process Doing > > 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 !!! > >=20 > > -----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 > >=20 > > hi ganesh, > >=20 > > 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.. > >=20 > > if in v$session, its inactive or dead you can kill that sid and > > serial#.. > >=20 > > ----- 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 > >=20 > > > Sorry here are the versions. > > >=3D20 > > > Solaris 64 Bit 9.2.0.5 > > >=3D20 > > > Thanks. > > >=3D20 > > >=3D20 > > > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja > > <ganesh.raja@xxxxxxxxx> wrote: > > > > Hi, > > > >=3D20 > > > > 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] > > > >=3D20 > > > > 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. > > > >=3D20 > > > > The weird thing is that that the CPU statistics for this process > are > > > > not being updated on v$sessstat > > > >=3D20 > > > > Any help is greatly appreciated. > > > >=3D20 > > > > Cheers > > > > Ganesh R > > > > > > >=3D20 > >=20 > > Good Luck..Subodh Deshpande > >=20 > > > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D > =3D3D=3D > > = > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D > > Experience Is Knowledge > > Wisdom Is Philosophy > > > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D > =3D3D=3D > > = > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= > 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D > >=20 > > --=3D20 > > _______________________________________________ > > 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=3D3Dlycos10 > >=20 > > > >