[askdba] Re: What is the Process Doing
- From: "Kurian Abraham" <kzabraham@xxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 17:24:08 +0530
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:
