Avatar of omarfarid
omarfarid
Flag for United Arab Emirates asked on

Oracle 10g RAC database TCP parameters on solaris 10

Please provide optimized TCP parameters on Soraris 10 (SPARC) for OLTP Oracle 10g RAC database for below TCP parameters

tcp_rexmit_interval_min
tcp_rexmit_interval_max
tcp_rexmit_interval_initial
tcp_ip_abort_interval
Unix OSOracle DatabaseTCP/IPDatabases

Avatar of undefined
Last Comment
omarfarid

8/22/2022 - Mon
Brian Utterback

Generally you should leave these at the defaults. However, if you are on a closed LAN with very small round trip times they can be tuned to be more efficient. The latest kernel update patch for Solaris 10 already reduces the tcp_rexmit_interval_initial parameter from 3 seconds to 1 second. You could go down to 500ms, but I wouldn't go lower than that. On the same token, you could reduce the tcp_rexmit_interval_min to 200ms. You should never reduce the tcp_ip_abort_interval below 1 minute, but the abort interval doesn't affect the transaction efficiency anyway.
omarfarid

ASKER
Thank you blu, can you provide more info on how to tune these parameters? Is there a document covering their tuning?

currently, my servers parameters values are as below:

h1 (sun v480):
#########
tcp_rexmit_interval_min=400
tcp_rexmit_interval_max=60000
tcp_rexmit_interval_initial=1000
tcp_ip_abort_interval=300000


h2 (sun v480):
#########
tcp_rexmit_interval_min=400
tcp_rexmit_interval_max=60000
tcp_rexmit_interval_initial=1000
tcp_ip_abort_interval=300000

z1 (sun v490):
########
tcp_rexmit_interval_min=400
tcp_rexmit_interval_max=60000
tcp_rexmit_interval_initial=3000
tcp_ip_abort_interval=480000

z2 (sun v480):
########
tcp_rexmit_interval_min=400
tcp_rexmit_interval_max=60000
tcp_rexmit_interval_initial=1000
tcp_ip_abort_interval=300000

Oracle support said "these parameter depends on customer environment and can vary up the h/w , network topologies, switch etc" but did not give any guidelines on how to set them or what are the recommended values.

This is related to radius restarts and we are suspecting connectivity issue with the oracle RAC database
ASKER CERTIFIED SOLUTION
Brian Utterback

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
omarfarid

ASKER
As I said, we are facing radius server crashes and suspection is twards database. There is a firewall in between the database RAC servers and the RADIUS server.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Brian Utterback

What I mean is, these prameters are dealing with the retransmissions of dropped packets at various stages of the connection. Is the problem you are experiencing related to dropped packets and aborted connections? Will faster or slower retransmissions help? Shorter or longer abort timeout?
omarfarid

ASKER
How to check if there are dropped packets on the servers themselves?
Brian Utterback

You can use netstat to see the retransmission counters for TCP.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
omarfarid

ASKER
Thanks for your support. The case is still open with Oracle