Installation Guide › System Requirements › Database Requirements › Increase Oracle Database Sessions and Process Parameters-A

Increase Oracle Database Sessions and Process Parameters-A

Increase database sessions and process parameters from the default settings to reduce exceptions.

Follow these steps:

1. Connect to the database with the system account.
2. Run the following commands:

   alter system set sessions=400 scope=spfile;
   

   alter system set processes=400 scope=spfile;
   

3. Restart the entire database (all cluster instances).

Database sessions and process parameters are increased.