43.In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is
the impact of this setting?
A.Optimizer statistics are collected automatically.
B.Only timed operating system (OS) statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
答案:B
解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams254.htm#REFRN10214
STATISTICS_LEVEL的含义如下:
这个参数指定了收集数据库和操作系统统计信息的级别,数据库收集这些信息有很大的作用,包括决定怎样进行自我管理
认设置为TYPICAL ,有三个级别,分别是ALL | TYPICAL | BASIC,最低的时basic也就是收集的是最少的
当在会话中动态修改STATISTICS_LEVEL的时候,系统的状态时不会发生变化的,包括如下一些信息
1.Timed statistics
2.Timed OS statistics
3.Plan execution statistics
因此选择B,但是文档中说的是在会话中动态修改,而题目中说的是初始化参数,感觉好像不是一回事
the impact of this setting?
A.Optimizer statistics are collected automatically.
B.Only timed operating system (OS) statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
答案:B
解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams254.htm#REFRN10214
STATISTICS_LEVEL的含义如下:
这个参数指定了收集数据库和操作系统统计信息的级别,数据库收集这些信息有很大的作用,包括决定怎样进行自我管理
认设置为TYPICAL ,有三个级别,分别是ALL | TYPICAL | BASIC,最低的时basic也就是收集的是最少的
当在会话中动态修改STATISTICS_LEVEL的时候,系统的状态时不会发生变化的,包括如下一些信息
1.Timed statistics
2.Timed OS statistics
3.Plan execution statistics
因此选择B,但是文档中说的是在会话中动态修改,而题目中说的是初始化参数,感觉好像不是一回事