在oracle 11g ,我们已经设置了memory_target的情况下,发现,sga_target,pga_aggregate_target也有值,现在想把sga_target,pga_aggregate_target参数设置为默认值,该如何操作?请写出操作步骤?

1.重置sga_target,pga_aggreagte_target参数到默认值

sql>alter system reset sga_target scope=spfile;

alter system reset pga_aggregate_target scope=spfile;

2.重启数据库修改生效.

sql>startup force;