Hi guys,

Output of show spfile:

Code:
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
Above confirms its not being used, so would ALTER SYSTEM SET ... SCOPE=SPFILE work. Also SGA_MAX_SIZE is set to 2GB (altough its not in any of the pfiles). So if i shutdown the instances, edit the SGA_TARGET to higher value and restart the instance the new values should be reflected.