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

From: Ricard Martínez <>
Date: Tue, 16 Feb 2010 15:31:48 +0100
Message-ID: <>

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 <>

> 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

Received on Tue Feb 16 2010 - 08:31:48 CST

Original text of this message