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.

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

Pd

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