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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 23 Aug 2004 11:10:33 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE90@usahm018.exmi01.exch.eds.com>

If it ran well in 8i and does not run well in 9i then this sounds like a tuning issue. Capture the SQL and compare the plans for the two different versions. If the 8i plan is unavailable then compare the current plan to what you think the plan ought to be. Recomputation of the statistics with a larger sample size might be helpful.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thomas Biju Sent: Monday, August 23, 2004 10:52 AM
To: oracle-l_at_freelists.org
Subject: RE: SQL*Net Message to client wait on batch job

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

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 - 10:07:32 CDT