FAQ
Great. Can we have ONE release where CS= works?

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*).

Pd

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 24, '04 at 10:20a
activeNov 24, '04 at 11:11a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase