1 Reply Latest reply: Oct 10, 2013 8:05 PM by TSharma-Oracle RSS

    Sql profile



      I ran sql tuning advisor and it generated  sql profile SYS_SQLPROF_013f8761185d0001'. My question is , how i can see the advisor recommendations? Do i have to see sql profile for recommendations and how i can see it? I ran

      SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'my_sql_tuning_task_1') from DUAL; but it does not show the recommendations. Please give some suggestions.