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>
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
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 12 2009 - 04:17:20 CDT