SQL Tuning Advisor

NOTE: The SQL Tuning Advisor needs Oracle Database Enterprise Edition with the SQL Tuning Pack

Autotask

JOB_START_TIME JOB_STATUS JOB_DURATION--------------------------------------------------------------------------- ------------------------------ --------------------------------------------18-NOV-18 06.00.02.260889 EUROPE/LONDON SUCCEEDED +000 00:36:0417-NOV-18 06.00.02.099488 EUROPE/LONDON SUCCEEDED +000 00:00:0816-NOV-18 22.00.00.916770 EUROPE/LONDON SUCCEEDED +000 00:22:0315-NOV-18 22.00.02.152454 EUROPE/LONDON SUCCEEDED +000 00:06:1314-NOV-18 22.00.02.220803 EUROPE/LONDON SUCCEEDED +000 00:35:0413-NOV-18 22.00.02.413984 EUROPE/LONDON SUCCEEDED +000 00:38:5612-NOV-18 22.00.02.112925 EUROPE/LONDON SUCCEEDED +000 00:40:45

Run SQL Tuning Advisor for a SQL_ID

Views

  • DBA_ADVISOR_TASKS

  • DBA_ADVISOR_FINDINGS

  • DBA_ADVISOR_RECOMMENDATIONS

  • DBA_ADVISOR_RATIONALE

  • DBA_AUTOTASK_JOB_HISTORY

  • DBA_SQLTUNE_STATISTICS

  • DBA_SQLTUNE_BINDS

  • DBA_SQLTUNE_PLANS

  • V$ADVISOR_PROGRESS