dbms_sqltune

DECLARE
my_task_name VARCHAR2(30);
my_sqltext CLOB;
BEGIN
my_sqltext := 'SELECT *
FROM lc_tun_temp
WHERE to_char(lcid) = ''1''';
my_task_name := dbms_sqltune.create_tuning_task(sql_text => my_sqltext,
bind_list => NULL,
user_name => 'APPS',
scope => 'COMPREHENSIVE',
time_limit => 60,
task_name => 'lc_tuning_task',
description => 'Tuning Task');
END;
BEGIN
dbms_sqltune.execute_tuning_task('lc_tuning_task');
END;
SELECT status
FROM user_advisor_tasks
WHERE task_name = 'lc_tuning_task';
SELECT dbms_sqltune.report_tuning_task('lc_tuning_task')
FROM dual;
BEGIN
dbms_sqltune.drop_tuning_task('lc_tuning_task');
END;

SELECT dbms_sqltune.extract_bind(bind_data, 1).value_string || '-' || dbms_sqltune.extract_bind(bind_data, 2)
.value_string || '-' || dbms_sqltune.extract_bind(bind_data, 3)
.value_string || '-' || dbms_sqltune.extract_bind(bind_data, 4)
.value_string || '-' || dbms_sqltune.extract_bind(bind_data, 5)
.value_string || '-' || dbms_sqltune.extract_bind(bind_data, 6)
.value_string
FROM DBA_HIST_SQLSTAT
WHERE sql_id = '88dz0k2qvg876';

SELECT * FROM dba_hist_sqlbind

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/59792/viewspace-1060412/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/59792/viewspace-1060412/