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

SQL>

Comments are closed.