sga_target kan alleen worden aangepast (mits binnen de scope van sga_maxsize) in de memory van de eigen instance.
dus voor instance 1
ALTER SYSTEM SET sga_target = 1G SCOPE=MEMORY SID=’db1′;
instance 2
ALTER SYSTEM SET sga_target = 1G SCOPE=MEMORY SID=’db2′
en instance 3 (eerst enablen en starten)
ALTER SYSTEM SET sga_target = 1G SCOPE=MEMORY SID=’db3′
FOUTEN: SQL> ALTER SYSTEM SET sga_target = 1G SCOPE=MEMORY SID=’both’; ALTER SYSTEM SET sga_target = 1G SCOPE=MEMORY SID=’both’ * ERROR at line 1: ORA-32018: parameter cannot be modified in memory on another instance
