## 限制 SGA_TAGGET
alter system set sga_target=6G scope=spfile;
## 限制 SGA_MAX_SIZE
alter system set sga_max_size=6G scope=spfile;
注意:需要重启oracle才能生效
## 限制 SGA_TAGGET
alter system set sga_target=6G scope=spfile;
## 限制 SGA_MAX_SIZE
alter system set sga_max_size=6G scope=spfile;
注意:需要重启oracle才能生效