Re: ODBC and Network Waits

1. the number of waits
2. the average time waited.

I'd lay a pound to a penny that b) was reasonable and a) was either unreasonable, or there were a very few very long waits on sqnet message from client - i.e the user or app.
showing the tkprof out put would of course mean that we didn't have to guess at these figures.
On Wed, Aug 12, 2009 at 10:17 AM, walid alkaakati <walid_alkaakati_at_yahoo.com
> wrote:

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

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l