Hi,
Environment:
O.S. - Windows server 2003 sp2
Database - Oracle 11g r2
Issue:
the software we are developing requires heaps of connections to a database (through JDBC).
At some stage, the sessions exceeds the limit and maxed out at 150.
Then I tried to use the following commands to change the limit:
alter system set processes=300 scope=spfile;
alter system set sessions=400 scope=spfile;
then restarted the database.
The limit did change from 150, however, to only 185 (checked from resources_limit.max utilisation), instead of 400 as I configured.
Also, the log file still showed maximum number of sessions exceeded so the connections were refused.
Question:
Is there anything more I need to do to change the limit to what I want? Or is there any other possible reasons to cause this failure of changing session limit?
Any help / reply would be much appreciated, thanks in advance.