RE: ODBC and Network Waits
From: Brian S Wisniewski <brian.s.wisniewski_at_jpmchase.com>
Date: Wed, 12 Aug 2009 15:21:00 -0400
Message-ID: <42AE61287BFA5C4993373C08F0E9FB22F166D7A6_at_EMARC07VS01.exchad.jpmchase.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of walid alkaakati Sent: Wednesday, August 12, 2009 5:17 AM To: oracle-l_at_freelists.org 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.
Date: Wed, 12 Aug 2009 15:21:00 -0400
Message-ID: <42AE61287BFA5C4993373C08F0E9FB22F166D7A6_at_EMARC07VS01.exchad.jpmchase.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of walid alkaakati Sent: Wednesday, August 12, 2009 5:17 AM To: oracle-l_at_freelists.org 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 12 2009 - 14:21:00 CDT