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