Re: EM Grid Control-Sql Advisor
- From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- To: drp4kri@xxxxxxxxx
- Date: Fri, 21 Sep 2007 09:28:49 +0200
sql tuning adv never changes the SQL, it usually gives 3 types of
recommendations:
1. add indexes
2. gather stats
3. profile: this is a bunch of hints giving the CBO more accurate
stats about the SQL (e.g. cardinalities of some columns, ....)
It may give advices of type 1 and 3, and you can choose to implement either
or all of the advices that it gives.
rgds
On 9/20/07, Dhimant Patel <drp4kri@xxxxxxxxx> wrote:
>
> Hi All,
>
> *In short: *
> Under 10g grid control, after running sql tuning advisor, I could see only
> old and new explain plans and a button with "Implement" but no description
> of
> what tuning advisor is going to do in order to ac hive new explain plan. I
> want to be able to see if
> 1> tuning advisor plans to modify the query AND/OR
> 2> add indexes/hints etc. So that I can undo if need to manually.
>
> At present I don't see this information is offered anywhere.
>
>
> *In Long:*
>
> I have an expensive query on which I ran SQL Tuning advisor under grid
> control. Now looking under
> Database Instance: <Name>
> <http://fire.reis.com:1158/em/console/database/instance/sitemap?event=doLoad&target=reisprod.fire.reis.com&type=oracle_database&pageNum=1>
> > Advisor
> Central<http://fire.reis.com:1158/em/console/database/instance/advisorTasks?event=reload&target=reisprod.fire.reis.com&type=oracle_database&dbPageNum=1>
> > *SQL Tuning Results:<Query_Name>* > *Recommendations for SQL
> ID:4wx9fm17gfhy8434 *
> I could see following sections.
> SQL Text: Underneath my sql query.
> Select Recommendation:
> I have buttons with "Original Explain Plan" "Implement" and a table with
> last column "New Explain Plan" with link to new and old explain plan
> compared.
>
>
>
> How can I obtain this info?
>
>
> -Thanks,
> DP.
>
>
Other related posts:
