关于053 第66题

66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?
(Choose two.)
A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
Answer: CE

13.02 题库中答案是CE，有的版本的答案选AC,个人认为还是应该选CE，我在自己电脑上验证如下：

SQL> show parameter target;


NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------
archive_lag_target                   integer     0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 1232M
memory_target                        big integer 1232M
parallel_servers_target              integer     16
pga_aggregate_target                 big integer 0
sga_target                           big integer 0

SQL> show parameter statistic


NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
optimizer_use_pending_statistics     boolean     FALSE
statistics_level                     string      TYPICAL
timed_os_statistics                  integer     0
timed_statistics                     boolean     TRUE

SQL> alter system set statistics_level=basic;
alter system set statistics_level=basic
*
第 1 行出现错误:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-00830: 启用自动优化 SGA 时无法将 statistics_level 设置为 BASIC