Re: Sql Tuning Advisor - how does this work?

julie_e_fleming_at_nps.gov wrote:
> I have installed Oracle 10g and imported my database and am
> experimenting with the SQL Tuning Advisor for our package bodies.
> When Oracle comes up with a better sql process, and you choose to
> 'Implement'', can someone tell me what actually happens? It does not
> change the code within the package body correct? It just stores the
> suggested sql somewhere and runs it when it sees the sql statement
> that was tuned?
>
> Thanks, I am learning Oracle and can't seem to find the answer to this.

Look at the recommendation:

SELECT command, attr1, attr3, attr4, attr5 FROM user_advisor_actions;

It can't change your package code. But it might implement materialized views, it might create indexes, it might use advanced rewrite, lots of possibilities.

Here are some links that might help:

http://www.psoug.org/reference/dbms_advisor.html
http://www.psoug.org/reference/indexes.html#ixns
http://www.psoug.org/reference/dbms_adv_rewrite.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org