Re: cursor_sharing

From: Ford <get4ked_at_yahoo.com>
Date: 30 Jul 2001 10:54:47 -0700
Message-ID: <b2b9197f.0107300954.2e9caf12@posting.google.com>

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 Mon Jul 30 2001 - 12:54:47 CDT