Using hash value or sql tuning number to see real select
From: Ricard Martínez <ricard.martinez_at_gmail.com>
Date: Tue, 16 Feb 2010 13:53:32 +0100
Message-ID: <345c71e81002160453q47a422efn3253ddc29170d33e_at_mail.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
Date: Tue, 16 Feb 2010 13:53:32 +0100
Message-ID: <345c71e81002160453q47a422efn3253ddc29170d33e_at_mail.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-lReceived on Tue Feb 16 2010 - 06:53:32 CST