SQL*Net message to|from client
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 9 Aug 2006 14:03:12 -0700 (PDT)
I am working on Siebel application and have found few stuff are working slow
and doing detailed traces with Waits shows that only wait events are
SQL*Net message to client'
SQL*Net message from client'
e.g
WAIT #3: nam='SQL*Net message to client' ela= 20 p1=1413697536 p2=1 p3=0
FETCH #3:c=10000,e=6433,p=0,cr=148,cu=0,mis=0,r=3,dep=0,og=2,tim=2307129653201
WAIT #3: nam='SQL*Net message from client' ela= 11978 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
FETCH #3:c=0,e=3948,p=0,cr=89,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129686923
WAIT #3: nam='SQL*Net message from client' ela= 2069 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
FETCH #3:c=0,e=3765,p=0,cr=90,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129693309
WAIT #3: nam='SQL*Net message from client' ela= 2170 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
FETCH #3:c=10000,e=3894,p=0,cr=89,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129699913
WAIT #3: nam='SQL*Net message from client' ela= 2049 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 5 p1=1413697536 p2=1 p3=0
FETCH #3:c=0,e=3784,p=0,cr=92,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129706294
WAIT #3: nam='SQL*Net message from client' ela= 2155 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 5 p1=1413697536 p2=1 p3=0
FETCH #3:c=0,e=3644,p=0,cr=89,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129712634
WAIT #3: nam='SQL*Net message from client' ela= 1982 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
FETCH #3:c=10000,e=3852,p=0,cr=89,cu=0,mis=0,r=2,dep=0,og=2,tim=2307129719011
WAIT #3: nam='SQL*Net message from client' ela= 140001 p1=1413697536 p2=1 p3=0
Any suggestion to look
Thanks
---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
Other related posts:
