Re: Hints....where are they stored....

"oracle_man" <oracle_man_at_yahoo.com> wrote in message news:1156196781.931055.275400_at_i3g2000cwc.googlegroups.com...
>I didn't mean hints in terms of stored outlines. I was hoping to look
> at the guts of the main hints such as parallel, use_nl, etc...
>

You used to be able to find the "names" of hints by doing a "strings -a" on the Oracle executable, or appropriate .o file, and hunting for an obvious hint like "star_transformation". Any text nearby was then another hint. You could find about 120 in 9.2 doing this.

But from 10.2 that's not possible, hints now seem to be just part of the list of reserved words, and I haven't yet found a way of identifying which reserved words really are hints.

-- 
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