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 13:53:32 +0100
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:
