<div>
you can not change &quot;sga_max_size&quot; using &quot;alter system ...&quot; so you have to go from pfile.
</div>


you can not change "sga_max_size" using "alter system ..." so you have to go from pfile.

<div>
<div class="content wysiwyg-content">
Oracle 10<br />
Win 2k3<br />
<br />
Hi,<br />
<br />
There are 3 instances, two of which have the SGA max size set to 276MB. &nbsp;I would like to reduce this to 160 so in OEM I changed the value, clicked apply and then restarted the server but when it comes back up it says 276MB again. &nbsp;What am I missing?<br />
<br />
thanks in advance
</div>
</div>


Oracle 10
Win 2k3

Hi,

There are 3 instances, two of which have the SGA max size set to 276MB.  I would like to reduce this to 160 so in OEM I changed the value, clicked apply and then restarted the server but when it comes back up it says 276MB again.  What am I missing?

thanks in advance

Resize SGA using OEM

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.