Shulou(Shulou.com)06/01 Report--

System:

Red Hat Enterprise Linux Server release 6.4 (Santiago)

Database: Oracle 11.2.0.4.171017

1 、 alter system set sga_target=5G scope=spfile

OR

Alter system set sga_target=5G scope=spfile sid='*'

The check did not take effect after restart

2. Create pfile view

As can be seen in the picture above,

Change SGA to 5G * .sga_max_size=5368709120

After restart, it is still in accordance with the

Rac1.sga_target=3221225472

Rac2.sga_target=3221225472

3. Solution: specify sid='SID' to modify sga_target to take effect without restarting the instance

Alter system set sga_target=5g scope=both sid='rac2'

Conclusion: the priority of Oracle rac instance level parameters is higher than that of global parameters!

Instance-level parameters take precedence over global parameters

Please refer to:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.