oracle-oc-043试题分类汇总.docxVIP

性能调优 1.You observe that a database performance has degraded over a period of time. While investigating the reason, you find the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component wold you refer to, in order to determine that required size of the database buffer cache? A. Memory Advisor B. Segment Advisor C. SQL Tuning Advisor D. SQL Access Advisor E. Automatic Database Diagnostic Monitor(ADDM) A 发现数据库运行一段时间后性能下降了，调查发现原因是因为buffer cache不能装下所有需要的数据块，用个工具确定数据库所需要的buffer cache的大小。 2.Exhibit --显示所有日志在同一个目录下 In your producti