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: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 23 Aug 2004 16:54:18 +0200
Message-Id: <200408231454.i7NEsI1s008428@webmail.nexlink.net>


 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, Stephane Faroult

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= 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= 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= elivery of message". How do I verify this?=20

Here is few lines of the trace output:

PARSING IN CURSOR #25 len=3D300 dep=3D0 uid=3D614 oct=3D2 lid=3D614 tim=3D2= 08054417239 hv=3D33
01285365 ad=3D'44820a70'
INSERT INTO PS_BR_PYT_PROJECTS (BUSINESS_UNIT, PROJECT_ID, BR_PAYOUT_ID, AC= TIVIT
Y_ID, ACCOUNT, ACCOUNT_TYPE, ACCOUNTING_DT, RESOURCE_ID, JOURNAL_ID, JOURNA= L_LIN
E, PRODUCT, CURRENCY_CD, BR_AO_PROP_XREF, ACTIVITY_TYPE, AMOUNT) VALUES ('B= R', :
1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) END OF STMT
EXEC #25:c=3D0,e=3D627,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208054417197

WAIT #25: nam=3D'SQL*Net message to client' ela=3D 5 p1=3D1229996800 p2=3D1= p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 862 p1=3D1229996800 p2=
=3D1 p3=3D0



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:45:52 CDT

Original text of this message

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