Re: Using hash value or sql tuning number to see real select
- From: Ricard Martínez <ricard.martinez@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Feb 2010 15:31:48 +0100
Hi all
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@xxxxxxxxx>
> 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
>
>
Other related posts:
