Oracle 11g 修改连接数

来源：互联网发布：c语言实现cp命令编辑：程序博客网时间：2024/04/27 23:23

查看当前最大连接数：

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                            // 当前最大连接数
SQL>

修改最大连接数

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

System altered.

重启数据库使修改生效：

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 4275781632 bytes

Fixed Size 2233336 bytes

Variable Size 3254782984 bytes

Database Buffers 1006632960 bytes

Redo Buffers 12132352 bytes

Database mounted.

Database opened.

查看当前最大连接数，看修改是否生效：

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   500                                // 修改后的最大连接数
SQL>

这一步骤还不太明白啥意思，只管先记录下来：）：

SQL> create pfile from spfile;

File created.