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.
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!