[askdba] Re: What is the Process Doing

  • From: "Kurian Abraham" <kzabraham@xxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Fri, 24 Sep 2004 18:21:53 +0530

Its very unlikey , that oradebug at level 12 has not written anything in
the trace .. !!!

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Ganesh Raja
Sent: Friday, September 24, 2004 6:20 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: What is the Process Doing

It will be empty .. And Yes There is Nothing in it at the Moment since
it is actively doing something ..


On Fri, 24 Sep 2004 18:08:45 +0530, Kurian Abraham
<kzabraham@xxxxxxxxxx> wrote:
> What is the content , are  u saying the trace file is empty ????
>=20
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
> On Behalf Of Ganesh Raja
> Sent: Friday, September 24, 2004 6:07 PM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Re: What is the Process Doing
>=20
> Kurian,
>=20
> The Trace file shows what is shwon on the v$session_wait view .. There
> ARE no WAITS.
>=20
> Cheers
> Ganesh R
>=20
> On Fri, 24 Sep 2004 18:01:44 +0530, Kurian Abraham
> <kzabraham@xxxxxxxxxx> wrote:
> > I am not referring to v$sess_io , I am asking you to look at I/O
stat
> at
> > the O/S level !!
> >=3D20
> > Look for the filesystem which shows a high amount of busy waits ..!!
> >=3D20
> > -----Original Message-----
> > From: askdba-bounce@xxxxxxxxxxxxx
[mailto:askdba-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Ganesh Raja
> > Sent: Friday, September 24, 2004 5:53 PM
> > To: askdba@xxxxxxxxxxxxx
> > Subject: [askdba] Re: What is the Process Doing
> >=3D20
> > Okay the Post again says that there is No IO Happening .. ;)
> >=3D20
> > On Fri, 24 Sep 2004 17:43:39 +0530, Kurian Abraham
> > <kzabraham@xxxxxxxxxx> wrote:
> > > Truss will surely help, whats happening to your  I/O ???
> > >=3D3D20
> > >=3D3D20
> > > -----Original Message-----
> > > From: askdba-bounce@xxxxxxxxxxxxx
> [mailto:askdba-bounce@xxxxxxxxxxxxx]
> > > On Behalf Of Ganesh Raja
> > > Sent: Friday, September 24, 2004 5:39 PM
> > > To: askdba@xxxxxxxxxxxxx
> > > Subject: [askdba] Re: What is the Process Doing
> > >=3D3D20
> > > 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 !!!!
> > >=3D3D20
> > > ~
> > > Ganesh
> > >=3D3D20
> > > 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
> > > >=3D3D3D20
> > > > Rg/-
> > > > Kurian
> > > >=3D3D3D20
> > > > -----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
> > > >=3D3D3D20
> > > > Kurian,
> > > >=3D3D3D20
> > > > 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 ... :)
> > > >=3D3D3D20
> > > > ~
> > > > Ganesh
> > > >=3D3D3D20
> > > > 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
> !!!
> > > > >=3D3D3D3D20
> > > > > -----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
> > > > >=3D3D3D3D20
> > > > > hi ganesh,
> > > > >=3D3D3D3D20
> > > > > 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..
> > > > >=3D3D3D3D20
> > > > > if in v$session, its inactive or dead you can kill that sid
and
> > > > > serial#..
> > > > >=3D3D3D3D20
> > > > > ----- 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
> > > > >=3D3D3D3D20
> > > > > > Sorry here are the versions.
> > > > > >=3D3D3D3D3D20
> > > > > > Solaris 64 Bit 9.2.0.5
> > > > > >=3D3D3D3D3D20
> > > > > > Thanks.
> > > > > >=3D3D3D3D3D20
> > > > > >=3D3D3D3D3D20
> > > > > > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja
> > > > > <ganesh.raja@xxxxxxxxx> wrote:
> > > > > > > Hi,
> > > > > > >=3D3D3D3D3D20
> > > > > > > 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]
> > > > > > >=3D3D3D3D3D20
> > > > > > > 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.
> > > > > > >=3D3D3D3D3D20
> > > > > > > The weird thing is that that the CPU statistics for this
> > process
> > > > are
> > > > > > > not being updated on v$sessstat
> > > > > > >=3D3D3D3D3D20
> > > > > > > Any help is greatly appreciated.
> > > > > > >=3D3D3D3D3D20
> > > > > > > Cheers
> > > > > > > Ganesh R
> > > > > > >
> > > > > >=3D3D3D3D3D20
> > > > >=3D3D3D3D20
> > > > > Good Luck..Subodh Deshpande
> > > > >=3D3D3D3D20
> > > > >
> > > >
> > >
> >
>
=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3=
D3D3D=3D3D3D3
D=3D
> 3D3D=3D3D3D3D3D3D
> =3D3D3D=3D3D
> > 3D3D3D=3D3D3D3D3D3D=3D3D3D3
> > D=3D3D3D
> > > 3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3
> > > D=3D3D3D3D
> > > > =3D3D
> >
>
3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3=
D3D3D3D=3D3D3
D=3D
> 3D3D3D=3D3D3D3D3D
> 3=3D3D
> > D=3D3D3D3D3D3D
> > > > =3D3D3D3D3D3D=3D3D3D3D3D
> > > > > =3D3D3D3D
> > > >
> > >
> >
>
=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3=
D3D3D=3D3D3D3
D=3D
> 3D3D=3D3D3D3D3D3D
> =3D3D3D=3D3D
> > 3D3D3D=3D3D3D3D3D3D=3D3D3D3
> > D=3D3D3D
> > > 3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3
> > > D=3D3D3D3D
> > > > =3D
>
3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3=
D3D3D3D=3D3D3
D=3D
> 3D3D3D
> > > > > Experience Is Knowledge
> > > > > Wisdom Is Philosophy
> > > > >
> > > >
> > >
> >
>
=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3=
D3D3D=3D3D3D3
D=3D
> 3D3D=3D3D3D3D3D3D
> =3D3D3D=3D3D
> > 3D3D3D=3D3D3D3D3D3D=3D3D3D3
> > D=3D3D3D
> > > 3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3
> > > D=3D3D3D3D
> > > > =3D3D
> >
>
3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3=
D3D3D3D=3D3D3
D=3D
> 3D3D3D=3D3D3D3D3D
> 3=3D3D
> > D=3D3D3D3D3D3D
> > > > =3D3D3D3D3D3D=3D3D3D3D3D
> > > > > =3D3D3D3D
> > > >
> > >
> >
>
=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3=
D3D3D=3D3D3D3
D=3D
> 3D3D=3D3D3D3D3D3D
> =3D3D3D=3D3D
> > 3D3D3D=3D3D3D3D3D3D=3D3D3D3
> > D=3D3D3D
> > > 3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3
> > > D=3D3D3D3D
> > > > =3D
> =
3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3D3D3D3D=3D3D3=
D3D3D3D
> > > > >=3D3D3D3D20
> > > > > --=3D3D3D3D3D20
> > > > > _______________________________________________
> > > > > 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=3D3D3D3D3D3Dlycos10
> > > > >=3D3D3D3D20
> > > > >
> > > >=3D3D3D20
> > > >
> > >=3D3D20
> > >
> >=3D20
> >
>=20
>




Other related posts: