ODBC and Network Waits

From: walid alkaakati <walid_alkaakati_at_yahoo.com>
Date: Wed, 12 Aug 2009 02:17:20 -0700 (PDT)
Message-ID: <670210.37126.qm_at_web65504.mail.ac4.yahoo.com>

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

Oracle 10g, Windows server 2003


Received on Wed Aug 12 2009 - 04:17:20 CDT

Original text of this message