在RAC中，就同一參數，給兩個執行個體分別指定不同的值

 RAC的兩個執行個體：

目前用spfile，job_queue_processes ＝4

SQL> col inst_name for a30
SQL> select * from v$active_instances;

INST_NUMBER INST_NAME
----------- ------------------------------
          1 cs_01:csrac1

 

          2 cs_02:csrac2

 

Elapsed: 00:00:00.00
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /dev/vg_cs1/rspfile_128m_01
SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     4
SQL>

 

現在在節點1上設定job_queue_processes=11 ，並且在節點2上設定job_queue_processes=12:
SQL> alter system set job_queue_processes=11 sid='csrac1';

System altered.

Elapsed: 00:00:00.05
SQL> alter system set job_queue_processes=12 sid='csrac2';

System altered.

Elapsed: 00:00:00.02
SQL>

檢查一下節點一：
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
csrac1

Elapsed: 00:00:00.01
SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     11
SQL>

再檢查一下節點2:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
csrac2

Elapsed: 00:00:00.02
SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     12
SQL>

現在看看spfile中是如何記錄的：

SQL> create pfile='/tmp/lunar.ora' from spfile;

File created.

Elapsed: 00:00:00.06
SQL> !cat /tmp/lunar.ora|grep job
*.job_queue_processes=4
csrac1.job_queue_processes=11
csrac2.job_queue_processes=12

SQL>