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

Home -> Community -> Usenet -> c.d.o.misc -> Re: turning off CURSOR_SHARING

Re: turning off CURSOR_SHARING

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 10 Aug 2004 00:58:02 GMT
Message-ID: <u4VRc.128279$bp1.70965@twister.nyroc.rr.com> 






"Ford Desperado" <ford_desperado_at_yahoo.com> wrote in message news:e96bc0d0.0408090537.43cf15e8_at_posting.google.com...


> I tried to turn off CURSOR_SHARING for one particular query, because

> it involves a predicate on a column with data skew and a range

> rpedicate.

> Is there any optimizer hint for that?

>

> TIA



Try:



select /*+ CURSOR_SHARING_EXACT */  ......




Anurag
Received on Mon Aug 09 2004 - 19:58:02 CDT












Original text of this message













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