This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
info:oracle:resize_instance [2013-02-04 22:17] 127.0.0.1 external edit |
info:oracle:resize_instance [2013-03-01 20:38] (current) andunix |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Oracle: Resize Instance ====== | ====== Oracle: Resize Instance ====== | ||
- | This page was moved to http://andunix.net/ | + | |
+ | In this example, the SGA will be resized | ||
+ | |||
+ | 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> |