ODBC and Network Waits

  • From: walid alkaakati <walid_alkaakati@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 12 Aug 2009 02:17:20 -0700 (PDT)

I have an application that uses ODBC and c++ ,i have checked the network 
latency and it is acceptable but the database as a whole  shows high wait 
levels of  
  SQL*Net message to client                            
  SQL*Net more data to client                                    
  SQL*Net message from client
I have traced  one slow SQL with TKPROF and i found a high cpu for parsing and 
fetching but also i found these wait events only.
My question has any one faces related problems to ODBC for example bugs,data 
send and recevied ,network....  i want to be sure it is only an application 
Oracle 10g, Windows server 2003


Other related posts: