Monday, September 27, 2010

Dynamically SGA increase ORACLE 10G Database

Step 1:
Login in
>export ORACLE_SID=test

>sqlplus /nolog

> conn / as sysdba or conn sys/password as sysdba


>ALTER SYSTEM SET sga_max_size = 1711276032 COMMENT='internally adjusted' SCOPE=SPFILE;

>ALTER SYSTEM SET sga_target = 1711276032 SCOPE=BOTH;



Step 2:

>shutdown immediate

>startup

>show sga


Finally you can see your expected SGA size