ORACLE基础知识----获取链接数
select * from v$session where username is not nullselect username,count(username) from v$session where username is not null group by username #查看不同用户的连接数 select count(*) from v$session #连接数Select count(*) from v$session where status='ACTIVE' #并发连接数show parameter processes #最大连接alter system set processes = value scope = spfile;重启数据库 #修改连接/home/oracle9i/app/oracle9i/dbs/init.ora/home/oracle9i/app/oracle9i/dbs/spfilexxx.ora ## open_cursor
