Oracle修改最大进程数

查看最大进程数

SQL>  show parameter processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
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> select count(*) from v$session;

  COUNT(*)
----------
        22

查看活动连接数/迸发数

SQL> Select count(*) from v$session where status='ACTIVE';

  COUNT(*)
----------
        20

修改最大进程数

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

System altered.

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

Total System Global Area 9787547648 bytes
Fixed Size                  2261568 bytes
Variable Size            1677725120 bytes
Database Buffers         8086618112 bytes
Redo Buffers               20942848 bytes
Database mounted.
Database opened.
SQL> show parameter processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
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     300
SQL>