Re: SQL*Net Message to client wait on batch job
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Aug 2004 16:54:18 +0200
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@xxxxxxxxxx> 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@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:
