读书人

ORACLE基础知识-获取链接数

发布时间: 2012-09-07 10:38:15 作者: rapoo

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









读书人网 >其他数据库

热点推荐