最近，公司DB的使用人员越来越多，系统连接数不够用，经常达到上限，导致有的用户无法登录连接数据库。
SQL> 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
mts_sessions integer 0
sessions integer 390
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
job_queue_processes integer 0
log_archive_max_processes integer 1
processes integer 350
SQL> select a.qty as se_qty,b.qty as pr_qty
2 from
3 (select count(*) as qty from v$session) a,
4 (select count(*) as qty from v$process) b
5 ;
SE_QTY PR_QTY
---------- ----------
296 297
Tag: Oracle Oracle基础 TTTBLOG