This content has been marked as final. Show 4 replies
1 person found this helpful
user11969485 wrote:Limit is controlled by OS configuration
i changed session and processes parameter in init ora file to 2400 and 1200 after that the database is not starting giving below error.
ORA-00064: object is too large to allocate on this O/S (1,4358400)
When I changed both parameters 500 & 550 it worked
And also let me know is there any calculation to set the parameters of session and process example session value should be double of process value?
ORA-00064: object is too large to allocate on this O/S [ID 283980.1]
ORA-00064 Error Reported After Increasing Processes Parameter value [ID 1457812.1]
SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number ofconcurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.1 person found this helpful
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes. The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.
Check your operating system-specific Oracle documentation for the range of processes values
I followed said docs and resolved the issue but I have a doubt “how to calculate which size I need to put there (init.ora) that error does not appear”