RE: ODBC and Network Waits
- From: Brian S Wisniewski <brian.s.wisniewski@xxxxxxxxxxxx>
- To: "walid_alkaakati@xxxxxxxxx" <walid_alkaakati@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Aug 2009 15:21:00 -0400
One issue I ran into a couple years ago with waits like these was due to the
way the developer coded the procedure with the out variable . He defined it as
char and it was sending back 32767 bytes and a ton of empty packets across the
network for each call. You can do a 10079 trace, level 2 trace to trace the
sql*net and see what it's sending across. Just something to think about.
- Brian
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of walid alkaakati
Sent: Wednesday, August 12, 2009 5:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ODBC and Network Waits
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
This communication is for informational purposes only. It is not
intended as an offer or solicitation for the purchase or sale of
any financial instrument or as an official confirmation of any
transaction. All market prices, data and other information are not
warranted as to completeness or accuracy and are subject to change
without notice. Any comments or statements made herein do not
necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect
that might affect any computer system into which it is received and
opened, it is the responsibility of the recipient to ensure that it
is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss
or damage arising in any way from its use. If you received this
transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.
Please refer to http://www.jpmorgan.com/pages/disclosures for
disclosures relating to European legal entities.
Other related posts:
