[askdba] Re: What is the Process Doing
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 13:20:04 +0100
Okay the Level 12 U mean here is the Trace Sesson Level Rite .. The
Session is Not going to be Tracing anything since the trace Fileshows
the Waits and Not what the Process is Currently Doing..
Kurian.. Thanks for the Thoughts .. It did not immd strike me that u
are asking me to enable Trace thru Oradebug ... See two mistakes in
one Post !!!! Too much ..
Sorry
Cheers
Ganesh
On Fri, 24 Sep 2004 13:13:26 +0100, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
> 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:
