Resize System Global Area (SGA)

From WickyWiki

Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (3 revisions)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

For example sga_target= 512M:

connect sys/pwd as sysdba
show parameter sga
alter system set sga_max_size = 512M scope = spfile;
shutdown immediate
startup
show parameter sga

Retrieved from "https://wjv.duckdns.org/mediawiki/index.php?title=Resize_System_Global_Area_(SGA)&oldid=1501"