info:oracle:resize_instance
Please note, that this is an old archived version of this site.
Check out the new version at andunix.net!
Differences
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> | ||
info/oracle/resize_instance.1360016249.txt.gz · Last modified: 2013-03-01 20:38 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution 4.0 International
