RE: 10.1.0.3: cursor_sharing = SIMILAR and ora-7445s

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 24 Nov 2004 10:45:09 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93F36@qtiexch2.qgraph.com>

Great. Can we have ONE release where CS=<something-besides-EXACT> works? <sigh>

Rich

-----Original Message-----
Sent: Wednesday, November 24, 2004 10:20 AM To: oracle-l_at_freelists.org
Subject: 10.1.0.3: cursor_sharing = SIMILAR and ora-7445s

10.1.0.3 / win32 (w2k svr sp4)
just a heads up - we're hit issues with cursor_sharing = SIMILAR in in ternal testing of 10g.

involving database links (where cursor_sharing = EXACT has to be used)
involving somewhat complex queries using GROUPING

setting cursor_sharing=EXACT relieved the symptoms. going to try cursor_sharing_exact hint.
we're still not ready for cursor_sharing=EXACT in production if we want less than a 42% miss rate in the library cache sql area (*choke*).

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 24 2004 - 10:41:36 CST