I am wondering if anyone knows the SQL to increase the number of concurrent users allowed for a database. please email me at [email protected] if you do.
thanks!
deeanna.
Printable View
I am wondering if anyone knows the SQL to increase the number of concurrent users allowed for a database. please email me at [email protected] if you do.
thanks!
deeanna.
Edit the processes parameter in your init.ora. Shutdown and then startup your database.
POINT TO PONDER:
Check your /etc/system file (if on unix) to make sure you have enough limit set for the semaphores. If not bump them up, restart the server and now increase the #of processes in the init.ora file and start the instance.
Sam