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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Muqthar Ahmed Sent: Thursday, April 29, 2004 11:09 AM To: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------