SQL*Net Message to client wait on batch job
- From: "Thomas Biju" <BThomas@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Aug 2004 09:41:17 -0500
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
EXEC #25:c=3D0,e=3D129,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208054418496
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 761 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D110,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208054419463
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 768 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D123,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208054420451
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 769 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D107,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208054421422
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 0 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 1677 p1=3D1229996800 p=
2=3D1 p3=3D0
<SNIP>
SELECT A.BUSINESS_UNIT, A.BR_PAYOUT_ID, A.PROJEC
T_ID, A.BR_AO_PROP_XREF, B.PROJECT_ID, D.PROJECT_ID, B.ACTIVITY_ID, B.ACCOU=
NT, C
=2EACCOUNT_TYPE, B.ACCOUNTING_DT, B.RESOURCE_ID, B.JOURNAL_ID, B.JOURNAL_DA=
TE, B.J
OURNAL_LINE, B.PRODUCT, C.BR_JIB, C.BR_ACCT_IDC_TAN, B.CURRENCY_CD, D.ACTIV=
ITY_T
YPE, B.RESOURCE_AMOUNT, A.BR_UNIT_FLAG FROM PS_BR_PYT_HEADER A, PS_PROJ_RE=
SOURC
E B, PS_GL_ACCOUNT_TBL C, PS_PROJ_ACTIVITY D WHERE A.EFFDT =3D (SELECT MAX(=
EFFDT)
FROM PS_BR_PYT_HEADER WHERE A.BUSINESS_UNIT =3D BUSINESS_UNIT AND A.BR_PAYO=
UT_ID =3D
BR_PAYOUT_ID AND EFFDT <=3D SYSDATE) AND A.BUSINESS_UNIT =3D 'BR' AND A.EF=
F_STATUS
NOT IN ('I','R') AND C.EFFDT =3D (SELECT MAX(EFFDT) FROM PS_GL_ACCOUNT_TBL =
WHERE C
=2ESETID =3D SETID AND C.ACCOUNT =3D ACCOUNT AND EFFDT <=3D SYSDATE) AND A.=
BUSINESS_UNIT
=3D B.BUSINESS_UNIT AND A.BUSINESS_UNIT =3D D.BUSINESS_UNIT AND B.BUSINESS=
_UNIT =3D D
=2EBUSINESS_UNIT AND ((A.PROJECT_ID =3D D.PROJECT_ID ) OR ( D.PROJECT_ID =3D=
A.BR_AO_P
ROP_XREF)) AND ((A.PROJECT_ID =3D B.PROJECT_ID ) OR (B.PROJECT_ID =3D A.BR_=
AO_PROP_X
REF)) AND B.PROJECT_ID =3D D.PROJECT_ID AND B.ACTIVITY_ID =3D D.ACTIVITY_ID=
AND B.AC
COUNT =3D C.ACCOUNT AND B.ANALYSIS_TYPE =3D 'ACT' AND B.RES_USER4 =3D 'Y' A=
ND C.SETID
=3D 'BR' and b.accounting_dt >=3D :1 and a.br_payout_id =3D :2 AND b.accou=
nting_dt >=3D
'01-JUL-2004' and b.accounting_dt < '01-AUG-2004'
END OF STMT
FETCH #7:c=3D13880000,e=3D13548845,p=3D0,cr=3D176933,cu=3D0,mis=3D0,r=3D5,d=
ep=3D0,og=3D4,tim=3D20806
7996944
WAIT #7: nam=3D'SQL*Net message from client' ela=3D 2251 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D621,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068000870
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 4 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 815 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D120,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068001923
EXEC #25:c=3D0,e=3D120,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068001923
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 0 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 776 p1=3D1229996800 p2=
=3D1 p3=3D0
WAIT #25: nam=3D'db file sequential read' ela=3D 14623 p1=3D52 p2=3D223260 =
p3=3D1
EXEC #25:c=3D0,e=3D14838,p=3D1,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,t=
im=3D208068017638
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 839 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D140,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068018728
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 836 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D110,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068019778
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 782 p1=3D1229996800 p2=
=3D1 p3=3D0
EXEC #25:c=3D0,e=3D122,p=3D0,cr=3D0,cu=3D8,mis=3D0,r=3D1,dep=3D0,og=3D4,tim=
=3D208068020784
WAIT #25: nam=3D'SQL*Net message to client' ela=3D 1 p1=3D1229996800 p2=3D1=
p3=3D0
WAIT #25: nam=3D'SQL*Net message from client' ela=3D 437 p1=3D1229996800 p2=
=3D1 p3=3D0
Thanks,
Biju Thomas
Database Administrator
*817-347-2064
*BThomas@xxxxxxxxxx
___________________________________________________________________________=
__________________________________
This electronic transmission and any attached files are intended solely for=
the person or entity to which they are addressed and may contain informati=
on that is privileged, confidential or otherwise protected from disclosure.=
Any review, retransmission, dissemination or other use, including taking a=
ny action concerning this information by anyone other than the named recipi=
ent, is strictly prohibited. If you are not the intended recipient or have =
received this communication in error, please immediately notify the sender =
and destroy this communication.
----------------------------------------------------------------
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:
