关于Oracle24.In your database,the STATISTICS_LEVEL initializat
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/09/28 21:29:49
关于Oracle
24.In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC.What is the impact
of this setting?
A.The optimizer statistics are collected automatically.
B.Only the timed operating system (OS) statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
能解释下这几个选项么?这个设定跟快照有什么关系?
24.In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC.What is the impact
of this setting?
A.The optimizer statistics are collected automatically.
B.Only the timed operating system (OS) statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
能解释下这几个选项么?这个设定跟快照有什么关系?
在你的数据库,STATISTICS_LEVEL初始化参数设置为基础.什么是影响
这个设置吗?
a.优化器所收集的自动统计.
b .只有定时操作系统(OS)统计和计划执行数据采集.
c.圣谕师服务器动态生成之必要的统计数据表查询优化的一部分.
d .的快照的自动工作量仓库(AWR)并不会自动产生.
d.大肠快照不能收集利用DBMS_WORKLOAD_REPOSITORY手动包裹.
这个设置吗?
a.优化器所收集的自动统计.
b .只有定时操作系统(OS)统计和计划执行数据采集.
c.圣谕师服务器动态生成之必要的统计数据表查询优化的一部分.
d .的快照的自动工作量仓库(AWR)并不会自动产生.
d.大肠快照不能收集利用DBMS_WORKLOAD_REPOSITORY手动包裹.
英语翻译are the principal beneficiaries of the database right in
ansys错误:the mesh in the ANSYS database has a discontinuity!E
英语翻译The Data in the Tucows Registrar WHOIS database is provi
英语翻译A thorough search in the Ingent,a database covering a wi
翻译:Required press information in database?
what's the advantage of database
英语翻译The Oracle database is the first database that is design
英语翻译A Database Error OccurredUnable to connect to your datab
database connect error , please check the connection 这是什么意思
1、David _______ on a new database at the moment.
the best friend in your
DataBase Assistant