This discussion is archived
1 Reply Latest reply: Nov 16, 2012 2:12 AM by Dom Brooks RSS

DBMS_SQLTUNE.REPORT

user10274093 Explorer
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points