Changing Oracle’s SGA size

To see the current values use ‘show parameter sga_target’. To alter:

alter system set sga_max_size = 300M scope=spfile; alter system set sga_target = 300M scope=spfile;

Restart database to effectuate change.

Leave a Reply

Your email address will not be published.

Scroll to top