How to modify oracle processes

Method: 1. Use the "alter system set processes=modified value scope=spfile" statement to modify the processes parameters; 2. Use the "shutdown immediate – startup" statement to restart the database to complete the modification.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to modify oracle processes

Step 1: Modify parameters

Single instance

alter system set processes=8000 scope=spfile;

RAC (modify on the master node , usually node one)

alter system set processes=8000 sid='*' scope=spfile;

Step 2: Restart the database

Single instance:

shutdown immediate – startup

RAC: Modify the parameters of multiple nodes After completion, you can restart the database at the same time

srvctl stop database -d orcl – srvctl start database -d orcl

You can also restart each node individually

srvctl stop database -d orcl1/2 – srvctl start database -d orcl1/2

Generally, after restarting the database and checking the parameters again, you can see that the parameters have been changed.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to modify oracle processes. For more information, please follow other related articles on the PHP Chinese website!