If an initialization parameter is the same for all nodes in the cluster,
it is prefixed with ???*.???; otherwise, it is prefixed with the node name.
In this example, the physical memory on the cluster server oc2 is temporarily reduced due
to other applications that are currently running on the server (ideally, though, you have no other
applications running on the server except for Oracle!). Therefore, to reduce the demands of the
instance on the server, you will change the value of MEMORY_TARGET for the instance rac2:
SQL> select sid, name, value
2 from v$spparameter where name = 'memory_target';
SID NAME VALUE
---------- -------------------- ----------------
* memory_target 423624704
SQL> alter system set memory_target = 256m sid='rac2';
System altered.
SQL> select sid, name, value
2 from v$spparameter where name = 'memory_target';
SID NAME VALUE
---------- -------------------- ----------------
* memory_target 423624704
rac2 memory_target 268435456
Once the memory issue has been resolved, you can restore the size of the shared pool on the
rac2 instance as follows:
SQL> alter system set memory_target = 404m sid='rac2';
System altered.
SQL>
Alternatively, and usually more simply, you want to reset the value to the same value for the
rest of the cluster; in this situation, you can use the reset option of the alter system command:
SQL> alter system reset memory_target sid = 'rac2';
System altered.
SQL> select sid, name, value
2 from v$spparameter where name = 'memory_target';
380 Oracle Database 11g DBA Handbook
SID NAME VALUE
---------- -------------------- ----------------
* memory_target 423624704
SQL>
RAC-related Initialization Parameters
A number of initialization parameters are used only in a RAC environment.
Pages:
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597