Hi,
In this topic
912615 someone replied:
>
Not sure I understand your question. If you set SGA_TARGET with SCOPE=MEMORY or BOTH, it should be in effect immediately.
...
>
And, as per the docs (http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory004.htm#autoId7):
>
Set the value of SGA_TARGET, either by editing the text initialization parameter file and restarting the database, or by issuing the following statement:
ALTER SYSTEM SET SGA_TARGET=value [SCOPE={SPFILE|MEMORY|BOTH}]
>
So, in 11gR2 when setting SGA_TARGET from a value of 0 to 1G for example, is it necessary to restart the database? So first the instance must be down, then set SGA_TARGET, and then issuing 'startup'?
I'm not clear.
Thanks.