Issues with Large SHMALL value
Hi,
I tried to look into Redhat documentation but could not find much about SHMALL parameter. I am experiencing database related issues like startup a database initially works but fails when try to bring it after some time. It just hangs even before starting SGA. I noticed a large SHMALL values in the system which is something like 4GB instead of 2MB recommended by oracle. at that time load goes crazy and all CPUs 100% utilized by system.
Please let me know if you ever had similar issues.
Thanks
|