17,082
社区成员
发帖
与我相关
我的任务
分享
Diagnoses:
SSQL> conn system/change_on_install as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as SYS
1、find session hight water
SQL> select * from v$license
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENTSESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
0 0 4 83 0
2、Current parameter process and session
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
job_queue_processes integer 0
log_archive_max_processes integer 2
processes integer 150
SQL> show parameter session
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
mts_sessions integer 0
session_cached_cursors integer 0
session_max_open_files integer 10
sessions integer 170
shared_server_sessions integer 0
Resolution:
SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=320 scope=spfile;
SQL> shutdown immediate;
SQL> startup;