[askdba] Re: What is the Process Doing
- From: "Kurian Abraham" <kzabraham@xxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Fri, 1 Oct 2004 15:24:54 +0530
Ganesh,
Thanks for the latest update on this thread=20
I am waiting for more on this
Thanks=20
Kurian
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Ganesh Raja
Sent: Friday, October 01, 2004 3:09 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: What is the Process Doing
Okay A Quick Updae for People still intrested in this Thread...=20
Oracle are thinking that we have hit an Hitherto undiscolled Bug in
9.2.0.5 which existed in 9.2.0.4 and suprisingly we did not hit it
there.
Will keep u posted once the Bug is Disclosed and POA Worked on.
Cheers
Ganesh R
On Mon, 27 Sep 2004 10:15:55 +0100, Ganesh Raja <ganesh.raja@xxxxxxxxx>
wrote:
> A Quick Update..
>=20
> Raised a TAR with oracle will update as soon as i can get some info.
>=20
> Cheers
> Ganesh R
>=20
>=20
> On Fri, 24 Sep 2004 14:07:23 +0100, Ganesh Raja
<ganesh.raja@xxxxxxxxx> wrote:
> > Anyways Found out that it is a Semaphore Setval Routine which is
being
>=20
>=20
> > called Repeatedly .. Any ideas ???
> >
> > ~
> > Ganesh
> >
> >
> > On Fri, 24 Sep 2004 13:57:07 +0100, Ganesh Raja
<ganesh.raja@xxxxxxxxx> wrote:
> > > 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) =3D 0
> > > semctl(9437185, 25, 8, 1) =3D 0
> > > semctl(9437185, 24, 8, 1) =3D 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
????
> > > > >=3D20
> > > > > -----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
> > > > >=3D20
> > > > > Kurian,
> > > > >=3D20
> > > > > The Trace file shows what is shwon on the v$session_wait view
.. There
> > > > > ARE no WAITS.
> > > > >=3D20
> > > > > Cheers
> > > > > Ganesh R
> > > > >=3D20
> > > > > 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 !!
> > > > > >=3D3D20
> > > > > > Look for the filesystem which shows a high amount of busy
waits ..!!
> > > > > >=3D3D20
> > > > > > -----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
> > > > > >=3D3D20
> > > > > > Okay the Post again says that there is No IO Happening .. ;)
> > > > > >=3D3D20
> > > > > > On Fri, 24 Sep 2004 17:43:39 +0530, Kurian Abraham
> > > > > > <kzabraham@xxxxxxxxxx> wrote:
> > > > > > > Truss will surely help, whats happening to your I/O ???
> > > > > > >=3D3D3D20
> > > > > > >=3D3D3D20
> > > > > > > -----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
> > > > > > >=3D3D3D20
> > > > > > > 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 !!!!
> > > > > > >=3D3D3D20
> > > > > > > ~
> > > > > > > Ganesh
> > > > > > >=3D3D3D20
> > > > > > > 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
> > > > > > > >=3D3D3D3D20
> > > > > > > > Rg/-
> > > > > > > > Kurian
> > > > > > > >=3D3D3D3D20
> > > > > > > > -----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
> > > > > > > >=3D3D3D3D20
> > > > > > > > Kurian,
> > > > > > > >=3D3D3D3D20
> > > > > > > > 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 ... :)
> > > > > > > >=3D3D3D3D20
> > > > > > > > ~
> > > > > > > > Ganesh
> > > > > > > >=3D3D3D3D20
> > > > > > > > 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
> > > > > !!!
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > -----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
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > hi ganesh,
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > 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..
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > if in v$session, its inactive or dead you can kill
that sid
> > > > and
> > > > > > > > > serial#..
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > ----- 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
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > > Sorry here are the versions.
> > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > Solaris 64 Bit 9.2.0.5
> > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > Thanks.
> > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja
> > > > > > > > > <ganesh.raja@xxxxxxxxx> wrote:
> > > > > > > > > > > Hi,
> > > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > > 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]
> > > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > > 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.
> > > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > > The weird thing is that that the CPU statistics
for this
> > > > > > process
> > > > > > > > are
> > > > > > > > > > > not being updated on v$sessstat
> > > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > > Any help is greatly appreciated.
> > > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > > > > Cheers
> > > > > > > > > > > Ganesh R
> > > > > > > > > > >
> > > > > > > > > >=3D3D3D3D3D3D20
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > Good Luck..Subodh Deshpande
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D=
3D=3D3D3D3D
3=3D
> > > > D3D3D=3D3D3D3D3
> > > > D=3D3D
> > > > > 3D3D=3D3D3D3D3D3D3D
> > > > > =3D3D3D3D=3D3D3D
> > > > > > 3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3
> > > > > > D=3D3D3D3D
> > > > > > > =
3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3
> > > > > > > D=3D3D3D3D3D
> > > > > > > > =3D3D3D
> > > > > >
> > > > >
> > > >
3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D=
3D3D=3D3D3D
3=3D
> > > > D3D3D3D=3D3D3D3
> > > > D=3D3D
> > > > > 3D3D3D=3D3D3D3D3D3D
> > > > > 3=3D3D3D
> > > > > > D=3D3D3D3D3D3D3D
> > > > > > > > =3D3D3D3D3D3D3D=3D3D3D3D3D3D
> > > > > > > > > =3D3D3D3D3D
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D=
3D=3D3D3D3D
3=3D
> > > > D3D3D=3D3D3D3D3
> > > > D=3D3D
> > > > > 3D3D=3D3D3D3D3D3D3D
> > > > > =3D3D3D3D=3D3D3D
> > > > > > 3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3
> > > > > > D=3D3D3D3D
> > > > > > > =
3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3
> > > > > > > D=3D3D3D3D3D
> > > > > > > > =3D3D
> > > > >
> > > >
3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D=
3D3D=3D3D3D
3=3D
> > > > D3D3D3D=3D3D3D3
> > > > D=3D3D
> > > > > 3D3D3D
> > > > > > > > > Experience Is Knowledge
> > > > > > > > > Wisdom Is Philosophy
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D=
3D=3D3D3D3D
3=3D
> > > > D3D3D=3D3D3D3D3
> > > > D=3D3D
> > > > > 3D3D=3D3D3D3D3D3D3D
> > > > > =3D3D3D3D=3D3D3D
> > > > > > 3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3
> > > > > > D=3D3D3D3D
> > > > > > > =
3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3
> > > > > > > D=3D3D3D3D3D
> > > > > > > > =3D3D3D
> > > > > >
> > > > >
> > > >
3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D=
3D3D=3D3D3D
3=3D
> > > > D3D3D3D=3D3D3D3
> > > > D=3D3D
> > > > > 3D3D3D=3D3D3D3D3D3D
> > > > > 3=3D3D3D
> > > > > > D=3D3D3D3D3D3D3D
> > > > > > > > =3D3D3D3D3D3D3D=3D3D3D3D3D3D
> > > > > > > > > =3D3D3D3D3D
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D=
3D=3D3D3D3D
3=3D
> > > > D3D3D=3D3D3D3D3
> > > > D=3D3D
> > > > > 3D3D=3D3D3D3D3D3D3D
> > > > > =3D3D3D3D=3D3D3D
> > > > > > 3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3
> > > > > > D=3D3D3D3D
> > > > > > > =
3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3
> > > > > > > D=3D3D3D3D3D
> > > > > > > > =3D3D
> > > > > =3D
> > > >
3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D3D3D=3D3D3D3D3D=
3D3D=3D3D3D
3=3D
> > > > D3D3D3D
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > > --=3D3D3D3D3D3D20
> > > > > > > > > _______________________________________________
> > > > > > > > > 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=3D3D3D3D3D3D3Dlycos10
> > > > > > > > >=3D3D3D3D3D20
> > > > > > > > >
> > > > > > > >=3D3D3D3D20
> > > > > > > >
> > > > > > >=3D3D3D20
> > > > > > >
> > > > > >=3D3D20
> > > > > >
> > > > >=3D20
> > > > >
> > > >
> > > >
> > >
> >
>
Other related posts:
