首页 > 代码库 > Performing a Quick Tune
Performing a Quick Tune
18.2.6 Performing a Quick Tune
To tune a single SQL statement, the QUICK_TUNE
procedure accepts as its input a task_name
and a SQL statement. The procedure creates a task and workload and executes this task. There is no difference in the results from using QUICK_TUNE
. They are exactly the same as those from using EXECUTE_TASK
, but this approach is easier to use when there is only a single SQL statement to be tuned. The syntax is as follows:
DBMS_ADVISOR.QUICK_TUNE ( advisor_name IN VARCHAR2, task_name IN VARCHAR2, attr1 IN CLOB, attr2 IN VARCHAR2 := NULL, attr3 IN NUMBER := NULL, task_or_template IN VARCHAR2 := NULL);
The following example shows how to quick tune a single SQL statement:
VARIABLE task_name VARCHAR2(255); VARIABLE sql_stmt VARCHAR2(4000); EXECUTE :sql_stmt := ‘SELECT COUNT(*) FROM customers WHERE cust_state_province =‘‘CA‘‘‘; EXECUTE :task_name := ‘MY_QUICKTUNE_TASK‘; EXECUTE DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name, :sql_stmt);
See Oracle Database PL/SQL Packages and Types Reference for more information regarding the QUICK_TUNE
procedure and its parameters.
http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94911
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。