Oracle maximum connections Session Process

Oracle maximum connections Session Process

Oracle maximum connections Session Process

1. view the processes and sessions Parameters
SQL> show parameter processes
Processes integer 50

SQL> show parameter sessions
Sessions integer 60

2. Modify the values of processes and sessions.
SQL> alter system set processes = 300 scope = spfile;
SQL> alter system set sessions = 335 scope = spfile;

Note:

<1>. to modify the processes and sessions values, the oracle service must be restarted to take effect.
<2> the number of Oracle connections (sessions) is related to the number of processes in the parameter file. sessions = (1.1 * process + 5)

3. Query
Query the number of connections of the current process in the database:
SQL> select count (*) from v $ process;

View the number of connections of the current session of the database:
SQL> select count (*) from v $ session;

View the number of concurrent connections of the database:
SQL> select count (*) from v $ session where status = 'active ';

View the Sessions established by the current database:
SQL> select sid, serial #, username, program, machine, status from v $ session;

Query the maximum number of connections allowed by the database:
SQL> select value from v $ parameter where name = 'processs ';
SQL> show parameter processes;

Check which users are using the data:
SQL> select oSUSEr,. username, cpu_time/executions/1000000 |'s, SQL _fulltext, machine from v $ session a, v $ sqlarea B where. SQL _address = B. address order by cpu_time/executions desc;

Note: one session in UNIX corresponds to an operating system process, while Windows is reflected in the thread.