cursor_sharing

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 30 Jul 2001 08:39:14 -0400
Message-ID: <a5lamtg4a8rima1i22aes13r1s31ugcl2g@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?

--
Chuck Hamilton
chuck_hamilton_at_yahoo.com

"Do not be deceived, God is not mocked; 
for whatever a man sows, this he will also
reap." (Gal 6:7 NASB)

Received on Mon Jul 30 2001 - 07:39:14 CDT