RE: Configure SDU and TDU parameters to improve Performance
- From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Apr 2004 14:09:50 -0400
Hi,
I am using Dynamic registration.
Server - 3 Nodes
Platform: IBM AIX
O/S: 5.1.05
Oracle: 9.2.0.5.0
Client - (IIS Webserver)
Platform: Windows
O/S: Win. 2000
Oracle Client: 9.2
Muqthar
DBA
http://www.decoratetoday.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Muqthar Ahmed
Sent: Thursday, April 29, 2004 12:28 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Configure SDU and TDU parameters to improve Performance
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
-----------------------------------------------------------------
* * * * * * * *
*
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
-----------------------------------------------------------------
Other related posts:
