Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CURSOR_SHARING force and similar

883641Feb 15 2012 — edited Feb 16 2012

Hello everyone,
In case of a session using mainly query against a PK of a table (different values each time),
is there any disadvantages of using ALTER SESSION SET CURSOR_SHARING=FORCE ?
And in case of a session using mainly query against a column with histogram (different values each time),
is there any disadvantages of using ALTER SESSION SET CURSOR_SHARING=SIMILAR ?
is it depend on the oracle edition (9i / 10g ..) ?

As far as I understand there isn't, but I tend to hear lots of DBAs saying setting this parameter to something else than EXACT will cause a lot of trouble.

I'm currently working on 11gr2

Thanks ! :)

This post has been answered by Nikolay Savvinov on Feb 15 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2012

Added on Feb 15 2012

#general-database-discussions

5 comments

571 views