查看当前连接数

select count(*) from v$process ;

查看允许最大连接数

select value from v$parameter where name ='processes' ;

查看当前连接情况

SELECT osuser,a.username,cpu_time/executions/1000000||'s',b.sql_text,machine from v$session a,v$sqlarea b where a.sql_address =b.address order by cpu_time/executions desc; select * from v$sgastat where pool='shared pool'; 查看当前回话数以及历史最高回话数，用来确定设置多大的连接数最合适。 select sessions_current,sessions_highwater from v$license;