Re: What is this Session Doing

From: Ganesh Raja <ganesh.raja_at_gmail.com>
Date: Fri, 24 Sep 2004 12:48:46 +0100
Message-ID: <f754edf0409240448282218f@mail.gmail.com>

Zhu,

Truss may give me some output. Will Try that.

But 10046 Should not give me anything rite because it is consuming CPU and not waiting for anything so the Trace file is Just Going to be Sitting there without writing anything to the File.

Cheers
Ganesh=20

On Fri, 24 Sep 2004 19:40:32 +0800, Zhu, Chao <chzhu_at_ebay.com> wrote:
> Hi,
> (It seems that my outlook is incompatible with oracle-l, so if it =
mess code, please forward it to the list).
> Try truss -p $pid , and find out what the process is doing in the =
unix level and using event 10046 to trace it in oracle.
> I have seen similar things on my solaris box. Maybe it is doing po=
ll() system call, or yield() system call.(I hit such problem). Workaround i= s to use another execution path for this specific SQL.
> V$sesstat won't update the statistics until the current SQL has fi=
nished.

>=20

> Regards
> Zhu Chao
> eBay e-commerce Technology Operations (Shanghai) Co.,Ltd.
> Tel: 86-21-32174588x8667
> Fax: 86-21-63404100
> 12/F., Raffles City Shanghai, No. 268 Xi Zang Road, Central
> Shanghai, China, 200001

>=20
>=20
>=20
>=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org=
] On Behalf Of Ganesh Raja
> Sent: 2004=E5=B9=B49=E6=9C=8824=E6=97=A5 18:29
> To: Oracle-L
> Subject: Re: What is this Session Doing

>=20

> Sorry here are the versions.

>=20

> Solaris 64 Bit 9.2.0.5

>=20

> Thanks.

>=20
> On Fri, 24 Sep 2004 11:28:12 +0100, Ganesh Raja <ganesh.raja_at_gmail.com> w=
rote:
> > Hi,
> >
> > 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]
> >
> > 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.
> >
> > The weird thing is that that the CPU statistics for this process are
> > not being updated on v$sessstat
> >
> > Any help is greatly appreciated.
> >
> > Cheers
> > Ganesh R
> >
> --
> http://www.freelists.org/webpage/oracle-l
>=20
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 24 2004 - 06:44:20 CDT