Re: Where is Oracle’s Grid ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 31 Dec 2003 09:07:16 -0800
Message-ID: <1072890351.363963@yasure>

Niall Litchfield wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1072827131.694131_at_yasure...
>

>>>So why can't Oracle let us change things (that's a knuckle-wrap for
>>>the hints-through-source mechanism)?
>>
>>Personally I'd like to see "hints" turned into "commands". I think I
>>should be able to not just hint but demand. Oracle seems to disagree.

>
>
> What do you mean by this? If you mean that Oracle can ignore valid hints
> then I believe that you are incorrect (and I need someone to explain to me
> how stored outlines work). If you mean that Oracle should not evaluate the
> hint for validity but just try to follow it, well actually I can't believe
> you mean that. My observation is that I cannot get Oracle to ignore
> correctly formed and valid hints, though I can easily enough fail to
> specify sufficient hints to force a specific access path. It seems to me
> that hints *are* commands (albeit they are checked for validity first).

I believe Oracle often ignores valid hints. I have tried to intentionally put together classroom demos with hints and been repeatedly frustrated by the hint being ignored.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Dec 31 2003 - 11:07:16 CST