Re: Using hash value or sql tuning number to see real select
Date: Tue, 16 Feb 2010 15:31:48 +0100
I answer myself, maybe can use it someday.
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
> I have the sql tuning number and the hash value of it, but ofc is not in
> Is there a way we can check the new select it is recomending us?