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!

Considerations for setting cursor_sharing=force

MattROct 3 2012 — edited Oct 4 2012

Hi all,

We have a vendor application that doesn't use of bind variables much at all and we're seeing a lot of hard parsing.
We're planning to implement cursor_sharing=FORCE in our 11.1.0.7 RAC database (currently set to EXACT).

I am interested if anyone has any tips or knows of anything to watch out for in implementing cursor_sharing=force.
I.e. bugs we could hit, potential performance degradations, any other lessons or tips that you may be able to share.

This is obviously going to be tested thoroughly in dev/qa before being implemented in production.

Appreciate any feedback you may be able to provide.

Cheers,
Matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2012

Added on Oct 3 2012

#11g, #general-database-discussions, #performance, #pl-sql

6 comments

611 views