Dbms_sqltune?

[Tuma]

hi all,
I used this to get a tuning recommendation. It finds that I need to accept and execute the proc below. I have done so. How do i see the results? What I do I do next? I have re-run my query but it made no difference. I guess i need to do something else but I don't know what.

thanks



DBMS_SQLTUNE.REPORT_TUNING_TASK('XFT_TASK')
--------------------------------------------------------------------------------
1- SQL Profile Finding (see explain plans section below)
--------------------------------------------------------
A potentially better execution plan was found for this statement.

Recommendation (estimated benefit: 70.08%)
------------------------------------------
- Consider accepting the recommended SQL profile.
execute dbms_sqltune.accept_sql_profile(task_name => 'XFT_TASK', replace
=> TRUE);

[PAVB]

I would use OEM instead but, you might want to check this....

http://www.adp-gmbh.ch/ora/plsql/dbms_sqltune.html