How to set processes & Sessions in Database

 

Below command is to Check Process & sessions:

SQL> select resource_name, current_utilization, max_utilization from v$resource_limit where resource_name in ('processes','sessions');     

                             

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION

------------------------------ ------------------- ---------------

processes                                      275             300

sessions                                       160             305

Below Command is to set process & Session

sql> alter system set processes=500 scope=spfile;

sql> alter system set sessions=555 scope=spfile;

Note: Once the database has been bounce the changes will effect.