本文讨论了如何验证在Oracle 10g数据库中通过计划任务更新的优化器统计数据是否已成功收集。具体介绍了应检查的三项关键指标：平均行大小、最后分析日期及表大小（以数据库块为单位）。这些信息有助于确保统计数据的准确性和有效性。
QUESTION 144:
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The
job has successfully completed. Which three pieces of information would you check to confirm that the statistics have
been collected? (Choose three.)
A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E - number of free blocks in the free list
F.number of extents present in the table
Answer :A, B, D
不理解为啥选b
谁给讲讲吧
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The
job has successfully completed. Which three pieces of information would you check to confirm that the statistics have
been collected? (Choose three.)
A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E - number of free blocks in the free list
F.number of extents present in the table
Answer :A, B, D
不理解为啥选b
谁给讲讲吧
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-136093/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/8135069/viewspace-136093/
扫一扫
1887
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
