sqltuneadivsor.txt

来自「在oracle中」· 文本 代码 · 共 25 行

--替换SQL TEXT
--替换SCHEMA
DECLARE
  my_task_name VARCHAR2(30);
  task_name    VARCHAR2(30):='my_sql_tuning_task';
  my_sqltext CLOB;
BEGIN
  my_sqltext := ' select * from user_info where user_name=''xxx''';
  my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
    sql_text => my_sqltext,
    bind_list => sql_binds(anydata.ConvertNumber(100)),
    user_name => 'SOSV3',
    scope => 'COMPREHENSIVE',
    time_limit => 60,
    task_name =>task_name,
    description => 'description');
  DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name =>task_name );
END;

--汇报结果
SET LONG 100000
SET LONGCHUNKSIZE 100000
SET LINESIZE 100
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'my_sql_tuning_task') FROM DUAL;