Home  >  Article  >  Database  >  How to modify oracle processes

How to modify oracle processes

WBOY
WBOYOriginal
2022-05-13 16:28:124004browse

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.

How to modify oracle processes

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn