自动内存管理与statistics_level

为什么80%的码农都做不了架构师？>>>   

Automatic Shared Memory Management simplifies the configuration of the SGA. To use Automatic Shared Memory Management, set the SGA_TARGET initialization parameter to a nonzero value and set the STATISTICS_LEVEL initialization parameter to TYPICAL or ALL.

sys@HUA>alter system set statistics_level=basic
  2  ;
alter system set statistics_level=basic
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

转载于:https://my.oschina.net/huayd/blog/138868