Modify Oracle,mysql maximum number of connections

1. Ways to modify the maximum number of connections for Oracle

A, landing in SYSDBA status of PL/SQL or Worksheet

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;

E. Restart the Oracle service or restart the Oracle server

2. How to query Oracle cursor usage

SELECT * from v$open_cursor where user_name = ' traffic ';

3. How to query Oracle session

SELECT * FROM V$session

To modify the maximum number of MySQL connections

MySQL maximum number of connections by default is 100

You can use the following command to modify the maximum number of connections for MySQL

Set GLOBAL max_connections= connection number;

For example:

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

After setting, use the command

Mysqladmin-uroot-p Variables | Find "Max_connect"

Enter Password:

| max_connections | 200

To see if the setting is successful

Modify Oracle,mysql maximum number of connections