[askdba] Re: What is the Process Doing

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 1 Oct 2004 10:39:19 +0100

Okay A Quick Updae for People still intrested in this Thread... 

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..
> 
> Raised a TAR with oracle will update as soon as i can get some info.
> 
> Cheers
> Ganesh R
> 
> 
> 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
> 
> 
> > 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)                       = 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: