RE: SQL*Net Message to client wait on batch job
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Aug 2004 11:10:33 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thomas Biju
Sent: Monday, August 23, 2004 10:52 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx]
Sent: Monday, August 23, 2004 9:54 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
