SQL*Net message to|from client

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 9 Aug 2006 14:03:12 -0700 (PDT)
Message-ID: <20060809210312.12135.qmail@web51315.mail.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 09 2006 - 16:03:12 CDT