This content has been marked as final. Show 4 replies
Perhaps there is already an instance specific setting in the spfile for instance1? In that case, the command you gave will have no effect.
How can i overcome that ? how can i increase the sga parameter?
Read up on the ALTER SYSTEM SET command, particularly the use of specifying the SID='instance_name' clause