The current content of the SQL cache contains the ideal workload for analysis.
You want to analyze only a few most resource-intensive statements.
What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?
A. Run the SQL Access Advisor.
B. Run the SQL Tuning Advisor(STA).
C. Run the Automatic Workload Repository(AWR)report.
D. Run the Automatic Database Diagnostic Monitor(ADDM).
答案:(A)
重复:610
解析:
SQL访问顾问是一个ADDM诊断指导,提供额外的支持,找出潜在的修改架构。这些潜在的模式可以用来减少I/O,CPU,和等待时间的总量对于一个给定的SQL语句。
指导也对潜在的有关索引和物化视图提出建议,提高系统的性能
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1348125/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1348125/