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