【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,27.5.2.4.1.sql,希望对大家有所帮助!
--创建一个SQL调整任务
conn sys/password as sysdba
grant advisor to user
conn user/pass
word DECLARE
my_task_name VARCHAR2(30);
my_sqltext CLOB;
BEGIN
my_sqltext := 'SELECT /*+ ORDERED */ * ' ||
'FROM employees e, locations l, departments d ' ||
'WHERE e.department_id = d.department_id AND ' ||
'l.location_id = d.location_id AND ' ||
'e.employee_id < :bnd';
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_text => my_sqltext,
bind_list => sql_binds(anydata.ConvertNumber(100)),
user_name => 'HR',
scope => 'COMPREHENSIVE',
time_limit => 60,
task_name => 'my_sql_tuning_task',
description => 'Task to tune a query on a specified employee');
END;
/
conn sys/password as sysdba
SELECT task_name FROM DBA_ADVISOR_LOG WHERE owner = 'user';