Re: cursor_sharing

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 4 Aug 2001 14:41:59 +0100
Message-ID: <996932350.22891.0.nnrp-10.9e984b29@news.demon.co.uk>

You could try the Oracle 9 hint

/*+ cursor_sharing_exact */

It probably won't work, but it is just possible that it exists in 8.1.7 but has not been documented - such things do happen from
time to time.

--
Jonathan Lewis

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

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Ford wrote in message ...


>You can use alter session set cursor_sharing = exact/force - theres

>nothing at the statement level in 817

>

>Chuck Hamilton <chuck_hamilton_at_yahoo.com> wrote in message

 news:<a5lamtg4a8rima1i22aes13r1s31ugcl2g_at_4ax.com>...


>> I have an 817 instance where cursor sharing has been enabled by

>> setting cursor_sharing = force. There are a few SQL statements however

>> where I'd like to disable it so that the optimizer will use

>> histograms. Is there a way to do this either at the SQL level with a

>> hint, or the session level?

Received on Sat Aug 04 2001 - 08:41:59 CDT