1 Reply Latest reply: Nov 16, 2012 4:12 AM by Dom Brooks RSS

    DBMS_SQLTUNE.REPORT

    user10274093
      Hi,
      on 11g R2 on Win I run in SQLPLUS:
      variable stmt_task VARCHAR2(64);
      
      EXEC :stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => ‘4rc7d8c0mvfm8');
      
      EXEC DBMS_SQLTUNE.EXECUTE_TUNING_TASK(:stmt_task);
      
      SET LINESIZE 140
      SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK(:stmt_task) from dual;
      
      DBMS_SQLTUNE.REPORT_TUNING_TASK(:STMT_TASK)
      -----------------------------------------------------------------
      GENERAL INFORMATION SECTION
      ----------------------------------------------------
      SQL>
      Is the report empty ? Nothing in it ? Why ?
      Thank you.