Oracle常用优化

设置sga_target和sga_max_size

SQL> show parameter sga;  #查看当前的值      

设置新的值

SQL> alter system set sga_max_size=10G  scope=spfile;
SQL> alter system set sga_target=10G  scope=spfile;      

shutdown immediate;
startup;