RE: SQL*Net Message to client wait on batch job

From: Thomas Biju <BThomas_at_br-inc.com>
Date: Mon, 23 Aug 2004 09:51:47 -0500
Message-ID: <75DFF91B31A1284992092BDB70C92324058419FD@ftwp45ns.br-inc.net>

Thank you. Unfortunately, this SQR was working good in Oracle8i and not so = good in Oracle9i. So it is "obviously" a database issue. :-) Also, we cannot change this to a pl/sql proc at this time.

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_roughsea.com] Sent: Monday, August 23, 2004 9:54 AM
To: oracle-l_at_freelists.org
Subject: Re: SQL*Net Message to client wait on batch job

Thomas,

Those waits are typical of a 'line-by-line' logic. The remark in Kirti'= s
book applies to (specifically) 'to client' (as opposed to 'from client') waits. Here you have both, which means that most of the time is spent blabbing on the network. I am ready to bet your insert is in a loop. If you really love loops, try to call a stored proc instead. But some INSERT ... SELECT ... would be far, far better.

HTH,=20 Stephane Faroult=20

On Mon, 23 Aug 2004 09:41 , 'Thomas Biju' <BThomas_at_br-inc.com> sent:

Hello gurus,

We upgraded Peoplesoft to Oracle9i over the weekend. So far everything work=
=3D

s great except one batch job. Did an extended trace and the waits are on SQL*net message event. I got the driver id and bytes (always 1 it se=
=3D

ems!!) from the trace file. But do not know where to go from here. Kirti's book says "the client process may be too busy to accept the d=
=3D

elivery of message". How do I verify this?=3D20

___________________________________________________________________________=
__________________________________

This electronic transmission and any attached files are intended solely for=
 the person or entity to which they are addressed and may contain informati=
on that is privileged, confidential or otherwise protected from disclosure.=
 Any review, retransmission, dissemination or other use, including taking a=
ny action concerning this information by anyone other than the named recipi=

ent, is strictly prohibited. If you are not the intended recipient or have = received this communication in error, please immediately notify the sender = and destroy this communication.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 23 2004 - 09:49:40 CDT