7、相关视图

　　DBA_ADVISOR_LOG
　　DBA_ADVISOR_TASKS
　　DBA_ADVISOR_FINDINGS
　　DBA_ADVISOR_RECOMMENDATIONS
　　DBA_ADVISOR_RATIONALE
　　DBA_SQLTUNE_STATISTICS
　　DBA_SQLTUNE_BINDS
　　DBA_SQLTUNE_PLANS

　　8、演示用到的脚本

 

SET ECHO OFF TERMOUT ON FEEDBACK OFF VERIFY OFF 
SET SCAN ON
SET LONG 1000000 LINESIZE 180
COL recs FORMAT a135

VARIABLE tuning_task VARCHAR2(30)

DECLARE
  l_sql_id v$session.prev_sql_id%TYPE;
BEGIN
  SELECT prev_sql_id INTO l_sql_id
  FROM v$session
  WHERE audsid = userenv('SESSIONID');
 
  :tuning_task := dbms_sqltune.create_tuning_task(sql_id => l_sql_id);
  dbms_sqltune.execute_tuning_task(:tuning_task);
END;
/

SELECT dbms_sqltune.report_tuning_task(:tuning_task) as recs
FROM dual;

SET VERIFY ON FEEDBACK ON