How do I change the maximum number of connection to Oracle database at start?
I use :
ALter system set sessions=500 scope=spfile;
However, after restart the database, use show parameter sessions still give value 772 for sessions
are you also changing PROCESSES parameter afterwards? sessions is a derived parameter.
Try changing sessions last?
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
5 years ago