>> You also don't mention what kind of applications you are running and
>> what file system you are using.
> Oracle 9
I am supporting a departmental server running 10g. It was upgraded from
22.214.171.124 64-bit on SuSE SLES 9 x86_64. The box is primarily designed for
desktop use, but a bit of work made it a fast and reliable DB and PHP
server. There are several possibilities you can search.
DB, OS and CPU must be 32 or 64 bit.
1. Check if you have the recommended package versions
glibc-devel-2.3.3-98.47 (required by gcc-3.3.3-43.34)
libstdc++-devel-3.3.3-43.34 (required by gcc-c++-3.3.3-43.34)
3. Kernel parameters in /etc/sysctl.conf
SHMMAX Set to half the size of physical RAM. max is 4294967295
Use "sysctl -p" to make changes effective
4. Check or add to /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
5. Make sure you have set /etc/pam.d/xdm and /etc/pam.d/su
session required /lib64/security/pam_limits.so
6. Bash profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65535
ulimit -u 16384 -n 65536
It is also a good idea to have a DB node and services' node.
Check JVM and Java processes - they can start several processes and use
significant amount of CPU.
orarun.rpm can be downloaded from
I hope this helps to spot the bottlenecks.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!