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;