Oracle 修改最大连接数

DBA连接oracle

> sqlplus /nolog
SQL> connect / as sysdba;
Connected.

查询当前最大连接数（Oracle默认是150）

SQL> show parameter processes;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 1
gcs_server_processes		     integer	 0
global_txn_processes		     integer	 1
job_queue_processes		     integer	 1000
log_archive_max_processes	     integer	 4
processes			     integer	 150

修改最大连接数（修改为1024，看需求和数据库系统性能而定）

SQL> alter system set processes = 1024 scope = spfile;

System altered.

关闭和重启数据库（需要新的参数才能生效）

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 3190132736 bytes
Fixed Size		    2217584 bytes
Variable Size		 2382367120 bytes
Database Buffers	  788529152 bytes
Redo Buffers		   17018880 bytes
Database mounted.
Database opened.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

重新查询当前最大连接数

SQL> show parameter processes;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 1
gcs_server_processes		     integer	 0
global_txn_processes		     integer	 1
job_queue_processes		     integer	 1000
log_archive_max_processes	     integer	 4
processes			     integer	 1024