2

I ran the Tuning Advisor on a query in Oracle SQL Developer. Under the SQL Profile tab there were two suggestions and I wanted to accept the first.

    execute dbms_sqltune.accept_sql_profile(task_name => 'staName',
        task_owner => 'DATA', replace => TRUE);

How do I accept the change or see what it is suggesting?

Kara
  • 111
  • 1
  • 4

1 Answers1

1

Copy and paste the SQL in SQL Developer and execute it.

To check the profiles use:

select * from dba_sql_profiles;

Particularly, look at the SQL_TEXT column

tale852150
  • 1,618
  • 3
  • 17
  • 23
  • but how do I understand what did it do actually? I can't understand what was it indexes or something else. `SQL_TEXT` is just my SQL that I was testing – Toolkit Feb 06 '17 at 13:30
  • and why the heck it keeps offering me Findings after I've accepted the previous one? – Toolkit Feb 06 '17 at 13:50