Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to modify the number of database connections in Oracle. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Modification of the number of Oracle database connections in windows system

You need to log in to dba to do the following: C:\ > sqlplus / as sysdba

1. View processes and sessions parameters

SQL > show parameter processes

SQL > show parameter sessions

two。 Modify processes and sessions values

SQL > alter system set processes=300 scope=spfile

SQL > alter system set sessions=335 scope=spfile

3. To change the processes and sessions values, you must restart the oracle service to take effect.

The number of connections (sessions) of an ORACLE is related to the number of processes (process) in its parameter file, and their relationship is as follows:

Sessions= (1.1*process+5)

Restart the database:

Shutdown immediate

Startup

4. Other inquiries

Query the number of connections in the current process of the database: select count (*) from v$process

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

Check the number of concurrent connections to the database: select count (*) from v$session where status='ACTIVE'

View the session of the current database establishment: select sid,serial#,username,program,machine,status from v$session

Maximum number of connections allowed to query the database: select value from v$parameter where name = 'processes'

Or: show parameter processes

See which users are currently using the data:

Select osuser,a.username,cpu_time/executions/1000000 | |'s magic journal sqlbook fulltext machine

From v$session a minute vainsqlarea b

Where a.sql_address = b.address

Order by cpu_time/executions desc

Note: UNIX 1 user session corresponds to an operating system process, while Windows is reflected in threads.

The above is the editor for you to share how to modify the number of database connections in Oracle, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.