Your problem is very complicated and need detailed informations.
1- What is your kernel version? Check it with uname?
2- What is your kernel parameters for oracle? (see Oracle installation documentation)
If these two parameters satisfy then we need to work on the dba side.
3- How many users are there in the system?
4- Is the system shared or dedicated
5- Are you using rac?
6- what is the result for ps - ef | grep oracle
7- check shared memory with pmap, vmstat or other commands.
8- Is your system hanging or crashing for that reason?
9- Are users getting any oracle error messages?
10- Can you post 'show parameters' output from the sqlplus.
I cant be sure at that point but it is most likely a performance tuning problem if it is not releated to redhat kernel (I think Redhat is the least reliable among other linux systems).
Last edited by sadun; 06-06-2005 at 02:17 AM.