????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