oracle默认账号和密码是什么自动内存管理与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.

 

1sys@HUA>alter system set statistics_level=basic2  2  ;3alter system set statistics_level=basic4*5ERROR at line 1:6ORA-02097: parameter cannot be modified because specified value is invalid7ORA-00830: cannot set statistics_level to BASICoracle账号 with auto-tune SGA enabled

 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。