本文介绍如何通过Oracle数据库中的DBMS_SQLTUNE包来运行SQL调优顾问。推荐使用企业管理器作为运行接口，若不可用时，则可通过DBMS_SQLTUNE包中的过程进行操作。整个流程包括创建SQL调优集、创建任务、执行任务及查看结果等步骤。
159.Which package provides API's for the SQL Tuning Advisor?
A. DBMS_MONITOR
B. DBMS_STATS
C. DBMS_SQLTUNE
D. DBMS_ADVISOR
Answer: C
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94855
Running SQL Tuning Advisor
The recommended interface for running SQL Tuning Advisor is Enterprise Manager. Whenever possible, run SQL Tuning Advisor using Enterprise Manager, . If Enterprise Manager is unavailable, then you can run SQL Tuning Advisor using procedures in the DBMS_SQLTUNE package. To use the APIs, the user must be granted specific privileges.
Running SQL Tuning Advisor using DBMS_SQLTUNE package is a multi-step process:
-
Create a SQL tuning set (if tuning multiple SQL statements)
-
Create a SQL tuning task
-
Execute a SQL tuning task
-
Display the results of a SQL tuning task
-
Implement recommendations as appropriate
扫一扫
514
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
