cursor_sharing=similar almost gone in 12c

September 10, 2013 — 1 Comment

in note 1169017.1 oracle announced that the setting of “similar” for the cursor_sharing parameter will be deprecated as of 12c: “The ability to set this will be removed in version 12 of the Oracle Database (the settings of EXACT and FORCE will remain available). Instead, we recommend the use of Adaptive Cursor Sharing in 11g.”

the current documentation is up to date and “similar” is not mentioned anymore, but:

SQL*Plus: Release Production on Fri Jun 28 15:33:34 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter sharing

------------------------------------ ----------- ------------------------------
cursor_sharing			     string	 EXACT
SQL> alter system set cursor_sharing='similar';

System altered.

SQL> show parameter sharing

------------------------------------ ----------- ------------------------------
cursor_sharing			     string	 similar

so, the ability to set this is still there …

One response to cursor_sharing=similar almost gone in 12c


    Hi Daniel,

    In the same note Doc ID 1169017.1 if you read through it they say:

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

    So looks like SIMILIAR=FORCE from and on. It wasn’t maybe so important to block it if it no longer works that way

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.