Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hints....where are they stored....

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 22 Aug 2006 10:53:19 -0700
Message-ID: <1156269198.301661@bubbleator.drizzle.com>


oracle_man wrote:

> 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...
> 
> Thanks for any replies,
> 
> rich
> 
> DA Morgan wrote:

>> oracle_man wrote:
>>> How can a extract the source for hints from the dictionary or other?
>>>
>>> Thanks in advance,
>>>
>>> Rich
>> Oracle version?
>> Hints where?
>>
>> Assuming you mean in a stored outline look at dba_outline_hints. This is
>> documented in Morgan's Library (www.psoug.org) under Outlines.
>> --
>> 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

>
  1. Please do not top post. Scroll to the bottom to reply.
  2. The documentation on hints is essentially nil. Something Jonathan Lewis has stated repeatedly during his seminars. I consider Jonathan's books and seminar notes the best source of information available. -- 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
Received on Tue Aug 22 2006 - 12:53:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US