SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :sql_stmt := 'SELECT COUNT(*) FROM customers WHERE cust_state_province=''CA'''; :task_name := 'MY_QUICKTUNE_TASK'; DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name, :sql_stmt); END; |
What is the outcome of this block of code?
A. It creates a task and workload,and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.
答案:(A)
解析:
参考DBMS_ADVISOR.QUICK_TUNE过程
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1249579/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1249579/