Re: sql_profile

"Akimeu" <Nospam_at_Email.com> wrote in message news:ri9Zg.7438$XX2.4019_at_dukeread04...
> Hi group,
>
> I have a recommended sql profile that the DBMS_SQLTUNE suggested
> ("...Oracle found a potentially better exec plan, and it says to
> accept_sql_profile (task_name=>etc.."), but before I execute this
> command - how do I view the details of the recommended profile?
>
> Thanks in advance,
> Al

If you have tune_NNNN as the task name, then

 select

    attr1
 from

    wri$_adv_rationale
 where

    task_id = NNNNN
;

should give you the list of hints that make up the profile.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html