Installation Guide › System Requirements › Database Requirements › Increase Database Sessions and Process Parameters

Increase Database Sessions and Process Parameters

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.