The following are some options to consider when tuning Solaris on x86 for Application Server and HADB:
Some of the values depend on the system resources available. After making any changes to /etc/system, reboot the machines.
Add (or edit) the following lines in the /etc/system file:
set shmsys:shminfo_shmmax=0xffffffff set shmsys:shminfo_shmseg=128 set semsys:seminfo_semmnu=1024 set semsys:seminfo_semmap=128 set semsys:seminfo_semmni=400 set semsys:seminfo_semmns=1024
These settings affect the number of semaphores and the shared memory. These are more relevant for the machine on which HADB server is running than for Application Server.
Add (or edit) the following lines in the /etc/system file:
set rlim_fd_max=65536 set rlim_fd_cur=65536 set sq_max_size=0 set tcp:tcp_conn_hash_size=8192 set autoup=60 set pcisch:pci_stream_buf_enable=0
These settings affect the file descriptors.
Add (or edit) the following lines in the /etc/system file:
set ip:tcp_squeue_wput=1 set ip:tcp_squeue_close=1 set ip:ip_squeue_bind=1 set ip:ip_squeue_worker_wait=10 set ip:ip_squeue_profile=0
These settings tune the IP stack.
To preserve the changes to the file between system reboots, place the following changes to the default TCP variables in a startup script that gets executed when the system reboots:
ndd -set /dev/tcp tcp_time_wait_interval 60000 ndd -set /dev/tcp tcp_conn_req_max_q 16384 ndd -set /dev/tcp tcp_conn_req_max_q0 16384 ndd -set /dev/tcp tcp_ip_abort_interval 60000 ndd -set /dev/tcp tcp_keepalive_interval 7200000 ndd -set /dev/tcp tcp_rexmit_interval_initial 4000 ndd -set /dev/tcp tcp_rexmit_interval_min 3000 ndd -set /dev/tcp tcp_rexmit_interval_max 10000 ndd -set /dev/tcp tcp_smallest_anon_port 32768 ndd -set /dev/tcp tcp_slow_start_initial 2 ndd -set /dev/tcp tcp_xmit_hiwat 32768 ndd -set /dev/tcp tcp_recv_hiwat 32768