How to modify Oracle session

Method: 1. Use the "alter system set sessions=modified value scope=spfile" statement to modify the session parameters; 2. After modifying the parameters, use the "shutdown immediate – startup" statement to restart the server and it will take effect.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to modify session in Oracle

1. Modify the values ​​of processes and sessions

SQL> alter system set processes=500 scope=spfile;
系统已更改。
SQL> alter system set sessions=555 scope=spfile;
系统已更改。

3. To modify the values ​​of processes and sessions, you must restart the oracle server To take effect

shutdown immediate – startup

The number of ORACLE connections (sessions) is related to the number of processes (process) in its parameter file. Their relationship is as follows:

sessions=(1.1*process 5)

Extended knowledge:

View processes and sessions parameters

SQL> show parameter processes
SQL> show parameter sessions

Query the number of connections of the current process in the database

SQL> select count(*) from v$process;

View the current number of connections in the database Number of session connections

SQL> select count(*) from v$session;

View the number of concurrent connections to the database

SQL> select count(*) from v$session where status='ACTIVE';

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to modify Oracle session. For more information, please follow other related articles on the PHP Chinese website!