====== Oracle: Resize Instance ======

In this example, the SGA will be resized to 6GB and the PGA to 2GB.

First, change the [[spfile_and_pfiles|SPFile]]:

<code sql>
ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE;
ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE;
</code>

Then, (optionally) export the SPFile to a PFile:

<code sql>
CREATE PFILE FROM SPFILE;
</code>

Finally, reboot the instance to activate the change:

<code sql>
SHUTDOWN IMMEDIATE;
STARTUP;
</code>

{{tag>admin oracle}}