Oracle view number of connections __oracle

Sometimes you have to go to the database and sometimes you can't even.

It is possible that the current number of connections on the database has exceeded the maximum value that it can handle.

Select COUNT (*) from v$process--current number of connections
Select value from v$parameter where name = ' processes '--maximum number of connections allowed by the database

To modify the maximum number of connections:
alter system SET processes = Scope = SPFile;

To restart the database:
Shutdown immediate;
Startup

--See which users are currently using the data
SELECT Osuser, a.username,cpu_time/executions/1000000| | ' S ', Sql_fulltext,machine
From V$session A, V$sqlarea b
where a.sql_address =b.address order by cpu_time/executions Desc; Select COUNT (*) from V$session #连接数

Select COUNT (*) from v$session where status= ' ACTIVE ' #并发连接数
Show parameter Processes #最大连接
alter system SET processes = value scope = spfile; Restart database #修改连接