1 查看processes,sessions参数
SYS>show parameter processes;
NAME
SYS>show parameter processes;
NAME
TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
SYS>show parameter sessions;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 170
shared_server_sessions integer
2 修改processes,sessions值
SYS>alter system set processes=300 scope=spfile;
SYS>alter system set sessions=335 scope=spfile;
修改processes,sessions值必须重启oracle服务器才能生效
sessions=(1.1*process+5)
3 查询数据库当前进程连接数
select count(*) from v$process;
4 查询数据库当前会话的连接数
select count(*) from v$session;
5 查看数据库的并发连接数
select count(*) from v$session where status='ACTIVE';
6 查看数据库建立的会话情况
select sid,serial#,username,programe,machine,status from v$session;
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
SYS>show parameter sessions;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 170
shared_server_sessions integer
2 修改processes,sessions值
SYS>alter system set processes=300 scope=spfile;
SYS>alter system set sessions=335 scope=spfile;
修改processes,sessions值必须重启oracle服务器才能生效
sessions=(1.1*process+5)
3 查询数据库当前进程连接数
select count(*) from v$process;
4 查询数据库当前会话的连接数
select count(*) from v$session;
5 查看数据库的并发连接数
select count(*) from v$session where status='ACTIVE';
6 查看数据库建立的会话情况
select sid,serial#,username,programe,machine,status from v$session;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27181165/viewspace-775869/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27181165/viewspace-775869/