RAC下修改process参数

修改process参数的大小，重启单个节点 另外的一个节点的参数不会变  重启后修改

也就是说如果是在RAC环境下修改process参数 需要重启所有的节点 才能生效。

节点1：

[oracle@ldbrac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 13 15:02:01 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>
SQL>
SQL> show parameter language

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_date_language                    string
nls_language                         string      AMERICAN
SQL>
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     150
SQL>
SQL> select count(*) from v$process;

  COUNT(*)
----------
        39

SQL> select count(*) from v$session;

  COUNT(*)
----------
        33

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

System altered.

SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     150
SQL> create pfile from spfile;

File created.

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

Total System Global Area  922746880 bytes
Fixed Size                  1222624 bytes
Variable Size             180357152 bytes
Database Buffers          734003200 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     200
SQL>

节点2：

[oracle@ldbrac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 13 15:13:49 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>
SQL>
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     150
SQL>
SQL>  show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     150
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area  922746880 bytes
Fixed Size                  1222624 bytes
Variable Size             239077408 bytes
Database Buffers          675282944 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     2
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     200
SQL>