Modify the maximum number of Oracle,mysql connections

1. The method of modifying the maximum number of connections in Oracle

A. Log in to PL/SQL or Worksheet as sysdba

B. Query the current number of connections

Show parameter processes

C. Change the number of system connections

Alter system set processes=1000 scope=spfile

D, create pfile

Create pfile from spfile

Restart the Oracle service or restart the Oracle server

2. Methods of querying the usage of Oracle cursors

Select * from v$open_cursor where user_name = 'TRAFFIC'

3. The method of querying Oracle session

Select * from v$session

Modify the maximum number of mysql connections

The maximum number of connections for MySQL is 100 by default

You can modify the maximum number of connections for Mysql using the following command

Number of set GLOBAL max_connections= connections

For example:

Set the new maximum number of connections to 200:mysql > set GLOBAL max_connections=200

After setting up, use the command

Mysqladmin-uroot-p variables | find "max_connect"

Enter password:

| | max_connections | 200 |

Let's see if the setting is successful.