Archive for June, 2009
« Previous Entries Next Entries »Linux Oracle tuning parameter : Disable Unnecessary Daemons
Friday, June 5th, 2009/sbin/chkconfig –levels 2345 sendmail off /sbin/chkconfig sendmail off
Linux Oracle tuning parameter : Tune TCP
Friday, June 5th, 2009To view current TCP settings, run command: sysctl net.ipv4.tcp_keepalive_time net.ipv4.tcp_keepalive_time = 7200 // 2 hours where net.ipv4.tcp_keepalive_time is a TCP tuning parameter. To set a TCP parameter to a value, run command: sysctl -w net.ipv4.tcp_keepalive_time=1800
Linux vs. Oracle Tuning, Error : ORA-00845: MEMORY_TARGET not supported on this system
Friday, June 5th, 2009The ORA-00845:can arises for the following two reasons on linux system. 1)If the shared memory which is mapped to /dev/shm directory is less than the size of MEMORY_TARGET or MEMORY_MAX_TARGET. or, 2)If the shared memory is not mapped to /dev/shm directory. Make sure /dev/shm is properly mounted. You can see it by, df -h Filesystem [...]
Linux Oracle tuning parameter : ulimits
Friday, June 5th, 2009To view current settings, run command: ulimit -a To set it to a new value for this running session, which takes effect immediately, run command: ulimit -n 8800 ulimit -n -1 // for unlimited; recommended if server isn’t shared Alternatively, if you want the changes to survive reboot, do the following: – Exit all shell [...]
Linux Oracle tuning parameter : Message queues
Friday, June 5th, 2009To view current settings, run command: more /proc/sys/kernel/msgmni more /proc/sys/kernel/msgmax To set it to a new value for this running session, which takes effect immediately, run command: echo 2048 > /proc/sys/kernel/msgmni echo 64000 > /proc/sys/kernel/msgmax
Linux Oracle tuning parameter : shmmax and shmall
Friday, June 5th, 2009maximum amount of memory = shmall * pagesize where pagesize = getconf PAGE_SIZE and shmall = cat /proc/sys/kernel/shmall
« Previous Entries Next Entries »