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

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

SQL*Net Message to client wait on batch job

From: Thomas Biju <BThomas_at_br-inc.com>
Date: Mon, 23 Aug 2004 09:41:17 -0500
Message-ID: <75DFF91B31A1284992092BDB70C92324035E62A7@ftwp45ns.br-inc.net> 





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_at_BR-Inc.Com



___________________________________________________________________________=
__________________________________

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_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:38:48 CDT












Original text of this message













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