Re: Using hash value or sql tuning number to see real select

SELECT DBMS_SQLTUNE.report_tuning_task('task number') AS recommendations FROM dual;

2010/2/16 Ricard Martínez <ricard.martinez_at_gmail.com>

> Hi all
> Im using sql tuning advisor from OEM 10g to check a select.
> The advisor say we can improve the select 99% and checkin explain plan i
> see its true.
> But i want to see the select advisor recomend us and no only the explain
> plan.
> I have the sql tuning number and the hash value of it, but ofc is not in
> v$sql.
> Is there a way we can check the new select it is recomending us?
> Thanks
>
>

--
http://www.freelists.org/webpage/oracle-l