[askdba] Re: What is the Process Doing

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

Retracting my statement there .. Will Try out and let u know .. 


On Fri, 24 Sep 2004 13:08:41 +0100, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
> 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
> > >
> >
> >
>

Other related posts: