Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Net Message to client wait on batch job

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

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 23 Aug 2004 10:57:21 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C65E@25exch1.vicorpower.vicr.com>


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.



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

-----------------------------------------------------------------
----------------------------------------------------------------
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:54:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US