| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Net Message to client wait on batch job
I believe you've already found the problem. Does this version of SQR =
support Oracle 9i? Something tells me that it doesn't.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Thomas Biju [mailto:BThomas_at_br-inc.com]
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 =3D
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'=3D
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,=3D20 Stephane Faroult=3D20
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
=3D3D
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
=3D3D
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
=3D3D
elivery of message". How do I verify this?=3D3D20
_________________________________________________________________________=__=3D
This electronic transmission and any attached files are intended solely =
for=3D
the person or entity to which they are addressed and may contain =
informati=3D
on that is privileged, confidential or otherwise protected from =
disclosure.=3D
Any review, retransmission, dissemination or other use, including =
taking a=3D
ny action concerning this information by anyone other than the named =
recipi=3D
ent, is strictly prohibited. If you are not the intended recipient or =
have =3D
received this communication in error, please immediately notify the =
sender =3D
and destroy this communication.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |