AANPASSEN SGA_TARGET BINNEN DE SGA_MAX_SIZE

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