RE: What is this Session Doing

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Tue, 28 Sep 2004 20:17:27 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BDC1@conmsx07.corp.acxiom.net>

Ganesh, did you also try running it non-parallel?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ganesh Raja Sent: Friday, September 24, 2004 6:49 AM To: Zhu, Chao
Cc: oracle-l_at_freelists.org
Subject: Re: What is this Session Doing

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


**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

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

Received on Tue Sep 28 2004 - 20:28:00 CDT