************************************************************************
****原文:blog.csdn.net/clark_xu 徐长亮的专栏
************************************************************************
问题描述:
原先SGA 4G,PGA 2G。
alter system set sga_max_size=30G scope=spfile;
alter system set sga_target=30G scope=spfile;
之后,
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
再次启动</