查看当前的连接数,可以用select count(*) from v$process;
查看当前oracle最大连接数(默认值为150) select value from v$parameter where name = 'processes';
修改最大连接数alter system set processes = 500 scope = spfile;
查看机器所占连接数 select count(1),machine from v$session group by machine
查看oracle目录
select * from dba_directories;