[askdba] Re: What is the Process Doing

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

Kurian,

it will not if the System is Not waiting and it is actively Processing
something.

That is what the trace is for finding out what the system is waiting
for .. and not know what the process is Doing ... :)

Anyways My Truss shows this .. [Repeatedly] Any ideas .. 

semctl(9437185, 26, 8, 1)                       = 0
semctl(9437185, 25, 8, 1)                       = 0
semctl(9437185, 24, 8, 1)                       = 0

Cheers
Ganesh R




On Fri, 24 Sep 2004 18:21:53 +0530, Kurian Abraham <kzabraham@xxxxxxxxxx> wrote:
> 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: