RE: What is this Session Doing
- From: "Zhu, Chao" <chzhu@xxxxxxxx>
- To: <ganesh.raja@xxxxxxxxx>
- Date: Fri, 24 Sep 2004 19:40:32 +0800
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 poll() =
system call, or yield() system call.(I hit such problem). Workaround is =
to use another execution path for this specific SQL.
V$sesstat won't update the statistics until the current SQL has =
finished.
=20
Regards
Zhu Chao
eBay e-commerce Technology Operations (Shanghai) Co.,Ltd.
Tel: 86-21-32174588x8667
Fax: 86-21-63404100=20
12/F., Raffles City Shanghai, No. 268 Xi Zang Road, Central=20
Shanghai, China, 200001=20
=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ganesh Raja
Sent: 2004=C4=EA9=D4=C224=C8=D5 18:29
To: Oracle-L
Subject: Re: What is this Session Doing
Sorry here are the versions.
Solaris 64 Bit 9.2.0.5
Thanks.
On Fri, 24 Sep 2004 11:28:12 +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
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
