Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
According to Google/Oracle Support, I have to increase the settings for maxuprc and maxusers but it did not give the formula on how much to increase it by.
Can someone please advise if they have any known "formula" to calculate what should be the ideal values for these two settings? Can I just pickup any random high numbers ... :) Setting these values are not mentioned in the Oracle Installation Guide.
Current values for these are as below:
maxuprc 29995
maxusers 2048
Any advise will be much appreciated. Thanks in advance.