[askdba] Re: What is the Process Doing

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

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 !!!
> 
> -----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
> 
> hi ganesh,
> 
> 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..
> 
> if in v$session, its inactive or dead you can kill that sid and
> serial#..
> 
> ----- 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
> 
> > Sorry here are the versions.
> >=20
> > Solaris 64 Bit 9.2.0.5
> >=20
> > Thanks.
> >=20
> >=20
> > On Fri, 24 Sep 2004 11:27:32 +0100, Ganesh Raja
> <ganesh.raja@xxxxxxxxx> wrote:
> > > Hi,
> > >=20
> > > 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]
> > >=20
> > > 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.
> > >=20
> > > The weird thing is that that the CPU statistics for this process are
> > > not being updated on v$sessstat
> > >=20
> > > Any help is greatly appreciated.
> > >=20
> > > Cheers
> > > Ganesh R
> > >
> >=20
> 
> Good Luck..Subodh Deshpande
> 
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Experience Is Knowledge
> Wisdom Is Philosophy
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> 
> --=20
> _______________________________________________
> 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=3Dlycos10
> 
>

Other related posts: