[askdba] Re: What is the Process Doing
- From: "Kurian Abraham" <kzabraham@xxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 17:58:17 +0530
Cool dude,
I hope you have done this --- SQL> oradebug event 10046 trace name
context forever, level 12
That is possible
Try tkprof on that file, see u get anything out of it ...
What is the wait event shown in the trace file ??
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Ganesh Raja
Sent: Friday, September 24, 2004 5:50 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: What is the Process Doing
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 ..
>=20
>=20
> 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
>=20
>=20
> > 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
!!!
> > > >=3D20
> > > > -----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
> > > >=3D20
> > > > hi ganesh,
> > > >=3D20
> > > > 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..
> > > >=3D20
> > > > if in v$session, its inactive or dead you can kill that sid and
> > > > serial#..
> > > >=3D20
> > > > ----- 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
> > > >=3D20
> > > > > Sorry here are the versions.
> > > > >=3D3D20
> > > > > Solaris 64 Bit 9.2.0.5
> > > > >=3D3D20
> > > > > Thanks.
> > > > >=3D3D20
> > > > >=3D3D20
> > > > > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja
> > > > <ganesh.raja@xxxxxxxxx> wrote:
> > > > > > Hi,
> > > > > >=3D3D20
> > > > > > 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]
> > > > > >=3D3D20
> > > > > > 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.
> > > > > >=3D3D20
> > > > > > The weird thing is that that the CPU statistics for this
process
> > > are
> > > > > > not being updated on v$sessstat
> > > > > >=3D3D20
> > > > > > Any help is greatly appreciated.
> > > > > >=3D3D20
> > > > > > Cheers
> > > > > > Ganesh R
> > > > > >
> > > > >=3D3D20
> > > >=3D20
> > > > Good Luck..Subodh Deshpande
> > > >=3D20
> > > >
> > >
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D=3D3
D=3D
> > > 3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > > =3D3D3D=3D3D
> > > > =3D
> > >
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D=3D3
D=3D
> > > 3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > > > Experience Is Knowledge
> > > > Wisdom Is Philosophy
> > > >
> > >
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D=3D3
D=3D
> > > 3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > > =3D3D3D=3D3D
> > > > =3D
> > >
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D=3D3
D=3D
> > > 3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > > >=3D20
> > > > --=3D3D20
> > > > _______________________________________________
> > > > 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=3D3D3Dlycos10
> > > >=3D20
> > > >
> > >
> > >
> >
>
Other related posts:
