61.Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
Answer: D
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF02802
题目问题是:在Oracle咨询框架中,下列哪个顾问将分析一个单一的SQL语句并对性能改进提出建议?
SQL优化指导可以对以下任一来源运行该指导:
活动SQL:分析当前活动的顶级SQL语句;
SQL优化集:分析用户提供的一组SQL语句;
以往的SQL(AWR):分析AWR快照捕获的SQL语句;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2121386/
,如需转载,请注明出处,否则将追究法律责任。