查看参数:
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;
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;