修改Oracle参数

查看参数：
show parameter;
 
查看recovery参数：
show parameter recovery;完全类似于系统命令：show parameter |grep recovery
 
修改参数：
 
alter system set sga_max_size=8G scope=spfile;
alter system set sga_max_size=8G scope=spfile;
 
 
alter system set shared_pool_size='2048M' scope=+ASM1;
alter system set shared_pool_size='2048M' scope=+ASM2;
 
alter system set sga_max_size=4096M scope=spfile;
alter system set sga_max_size=4096M scope=spfile;
 
 
alter system set db_recovery_file_dest_size=1200G;