自动内存管理与statistics_level

自动内存管理与statistics_level

 

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.

 

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