Donnerstag, 30. April 2009
How to change SGA size
In sqlplus, execute
ALTER SYSTEM SET sga_max_size = 4G SCOPE=spfile
shutdown immediate
startup
This is only for starting Oracle with spfile. If you execute
ALTER SYSTEM SET sga_max_size = 4G SCOPE=memory or
ALTER SYSTEM SET sga_max_size = 4G SCOPE=both
you will get
ORA-02095: specified initialization parameter cannot be modifie.
If oracle is automatic shared memory management (ASSM) mode, also execute
ALTER SYSTEM SET sga_target = 4G
Abonnieren
Kommentare zum Post (Atom)
Keine Kommentare:
Kommentar veröffentlichen