RE: cursor_sharing = SIMILAR and ora-7445s

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Nov 2004 10:45:09 -0600

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


-----Original Message-----
Sent: Wednesday, November 24, 2004 10:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: cursor_sharing = SIMILAR and ora-7445s / win32 (w2k svr sp4)
just a heads up - we're hit issues with cursor_sharing = SIMILAR in in
ternal testing of 10g.

1. involving database links (where cursor_sharing = EXACT has to be used)
2. 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



Other related posts: