How to Check and Change the Maximum Number of Oracle Database Connections?

Created: Apr 5, 2016 23:34:33Latest reply: Apr 6, 2016 09:01:50 1241 1 0 0 0

View the author ^1#

How to check and modify the maximum number of oracle database connections?

x
convention：
Emotion(0)

Like (0) Dislike (0) Favorite(0) Report

 Previous: why did you want to configure the proxy information?

Next: What Can I Do When eSight Installation Fails Due to Language Check Failure?



(0) (0)

^2#

NelsonBon Created Apr 6, 2016 09:01:50

1. Log in to the Linux operating system as the root user.
2. Connect to the Oracle database.

# su - oracle

$ sqlplus / as sysdba

3. Check the maximum number of Oracle database connections.

> select value from v$parameter where name = 'processes';

4. Change the maximum number of Oracle database connections to 500.

> alter system set processes = 500 scope = spfile;

5. Restart the Oracle database.

x
convention：

Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:

Politically sensitive content
Content concerning pornography, gambling, and drug abuse
Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy

Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.

Please bind your phone number to obtain invitation bonus.

Enterprise

Consumer

Corporate

Carriers

How to Check and Change the Maximum Number of Oracle Database Connections?

Third Party’s Trade Secret

My Followers