1 Reply Latest reply on Jul 8, 2016 11:45 PM by Gary Graham-Oracle

    Deprecating the Cursor_Sharing = 'SIMILAR' Setting (Doc ID 1169017.1)

    Dix0n

      All about the cursor_sharing = SIMILAR in Doc 1169017.1 applies on Oracle Database standar edition 11.2.0.4 ?

        • 1. Re: Deprecating the Cursor_Sharing = 'SIMILAR' Setting (Doc ID 1169017.1)
          Gary Graham-Oracle

          Although this is not the correct forum for such a question, it is simple enough to read the note and see that...

           

          1. It was last updated July 22, 2015, fairly recently given the multi-year roll-out seen in every Oracle DB release cycle.

          2. It specifically says Applies to:  Enterprise Edition 11.1.0.6, however, looking at the 11.1 doc, the optimizer is not a distinct, separately licensed feature...

          See https://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm

          Table 1-1 Feature Availability for Oracle Database Editions

          3. It specifically references 11.2.0.4...

          Note: In 11.2.0.3 and 11.2.0.4, although setting the parameter to SIMILAR will still be allowed, it will effectively behave as though cursor_sharing was set to FORCE.

          So it seems likely to be the same for Standard Edition, but to be cautious, it would be best to re-post the question in the most appropriate featured space under Database