Linux修改Oracle连接数

alter system set processes=500 scope=spfile;
alter system set sessions=500 scope=spfile;

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

 select count(*) from v$process;

 select count(*) from v$session;

SQL> shutdown immediate;
SQL> startup;

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;