From oracle-l-bounce@freelists.org Thu Apr 29 12:22:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3THME526082 for ; Thu, 29 Apr 2004 12:22:24 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3THM4626019 for ; Thu, 29 Apr 2004 12:22:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4D90B72D1A5; Thu, 29 Apr 2004 12:11:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02388-85; Thu, 29 Apr 2004 12:11:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9799272D96B; Thu, 29 Apr 2004 12:11:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 29 Apr 2004 12:10:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA34F72D1E9 for ; Thu, 29 Apr 2004 12:10:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02725-14 for ; Thu, 29 Apr 2004 12:10:23 -0500 (EST) Received: from mail.abwf.com (mail.abwf.com [65.114.91.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 452EF72D14A for ; Thu, 29 Apr 2004 12:10:23 -0500 (EST) Received: from mail01.abwf.com [172.16.18.12] by mail.abwf.com [172.16.19.47] (CMSPraetor 5.10.4411) with ESMTP id 8509F09317D6435391DD068AD1B773D6 for ; Thu, 29 Apr 2004 12:28:14 -0400 Received: by mail01.corp.abwf.com with Internet Mail Service (5.5.2655.55) id ; Thu, 29 Apr 2004 12:28:13 -0400 From: Muqthar Ahmed To: "'oracle-l@freelists.org'" Message-ID: <6362087FB073D41195B800D0B78284BE0621C9CD@mail01.corp.abwf.com> Subject: RE: Configure SDU and TDU parameters to improve Performance Date: Thu, 29 Apr 2004 12:28:04 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4037 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Muqthar.Ahmed@decoratetoday.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, I hope this output is readable: Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ------------ ---------- ---------- ------ -------- NODE1 SQL*Net more data to client 172,456 0 6 0 13.6 SQL*Net break/reset to clien 685 0 0 0 0.1 SQL*Net message from client 728,623 0 34,884 48 57.3 SQL*Net more data from clien 34,055 0 5 0 2.7 SQL*Net message to client 728,626 0 1 0 57.3 NODE2 SQL*Net more data to client 208,574 0 19 0 15.5 SQL*Net break/reset to clien 10 0 0 0 0.0 SQL*Net message from client 852,229 0 36,419 43 63.5 SQL*Net more data from clien 41,220 0 7 0 3.1 SQL*Net message to client 852,234 0 2 0 63.5 NODE3 SQL*Net more data to client 112,425 0 8 0 16.3 SQL*Net break/reset to clien 18 0 0 0 0.0 SQL*Net message from client 462,005 0 20,244 44 66.9 SQL*Net more data from clien 22,418 0 5 0 3.2 SQL*Net message to client 462,009 0 1 0 66.9 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ NODE1 SQL*Net roundtrips to/from client 725,847 769.7 57.1 bytes received via SQL*Net from c 188,354,007 199,739.1 14,822.9 bytes sent via SQL*Net to client 546,604,076 579,643.8 43,016.0 NODE2 SQL*Net roundtrips to/from client 852,882 916.1 63.5 bytes received via SQL*Net from c 224,478,043 241,115.0 16,722.1 bytes sent via SQL*Net to client 654,527,562 703,037.1 48,758.0 NODE3 SQL*Net roundtrips to/from client 462,472 496.8 67.0 bytes received via SQL*Net from c 122,075,296 131,122.8 17,671.6 bytes sent via SQL*Net to client 353,129,083 379,300.8 51,118.9 Thanks Muqthar -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Muqthar Ahmed Sent: Thursday, April 29, 2004 11:09 AM To: 'oracle-l@freelists.org' Subject: Configure SDU and TDU parameters to improve Performance Hi, I have a RAC system of 3 nodes with 7 webservers (clients). I would like to configure SDU/TDU parameters at client level to improve the performance. Reference: Note:69591.1 "SQL*Net Performance Tuning in Applications" Note:44694.1 "SQL*Net Packet Sizes (SDU & TDU Parameters)" The STATSPACK output is: Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ----------------- ---------------- ---------------- ----------------- --------------- NODE1 SQL*Net more data to client 172,456 0 6 0 13.6 SQL*Net break/reset to clien 685 0 0 0 0.1 SQL*Net message from client 728,623 0 34,884 48 57.3 SQL*Net more data from clien 34,055 0 5 0 2.7 SQL*Net message to client 728,626 0 1 0 57.3 NODE2 SQL*Net more data to client 208,574 0 19 0 15.5 SQL*Net break/reset to clien 10 0 0 0 0.0 SQL*Net message from client 852,229 0 36,419 43 63.5 SQL*Net more data from clien 41,220 0 7 0 3.1 SQL*Net message to client 852,234 0 2 0 63.5 NODE3 SQL*Net more data to client 112,425 0 8 0 16.3 SQL*Net break/reset to clien 18 0 0 0 0.0 SQL*Net message from client 462,005 0 20,244 44 66.9 SQL*Net more data from clien 22,418 0 5 0 3.2 SQL*Net message to client 462,009 0 1 0 66.9 Statistic Total per Second per Trans --------------------------------- ------------------------ --------------------- ---------------------- NODE1 SQL*Net roundtrips to/from client 725,847 769.7 57.1 bytes received via SQL*Net from c 188,354,007 199,739.1 14,822.9 bytes sent via SQL*Net to client 546,604,076 579,643.8 43,016.0 NODE2 SQL*Net roundtrips to/from client 852,882 916.1 63.5 bytes received via SQL*Net from c 224,478,043 241,115.0 16,722.1 bytes sent via SQL*Net to client 654,527,562 703,037.1 48,758.0 NODE3 SQL*Net roundtrips to/from client 462,472 496.8 67.0 bytes received via SQL*Net from c 122,075,296 131,122.8 17,671.6 bytes sent via SQL*Net to client 353,129,083 379,300.8 51,118.9 Any recommendations?????? Cary, Last week I have received your book in the mail. I started reading and I am in chapter 4........the concept about performance is completely different. Some of the examples / scenarios about managers / developers / end users you mentioned are so true. Thanks Muqthar Ahmed Database Administrator DecorateToday.com * * * * * * * * * The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- * * * * * * * * * The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------