OraFAQ Forum: SQL & PL/SQL » cursor

Home » SQL & PL/SQL » SQL & PL/SQL » cursor_sharing force 11g r2 (oracle 11g / 11gr2/unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cursor_sharing force 11g r2 [message #609280]

Wed, 05 March 2014 02:10

balaji123
Messages: 29
Registered: October 2009
Location: sanfrancisco

Junior Member

can we use cursor_sharing = force? Is there any drawback on sql performance ?

when it can be used? Please advise.

Report message to a moderator

Re: cursor_sharing force 11g r2 [message #609283 is a reply to message #609280]

Wed, 05 March 2014 02:13

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No, don't use it, there are many bugs.

Report message to a moderator

Re: cursor_sharing force 11g r2 [message #609284 is a reply to message #609280]

Wed, 05 March 2014 02:14

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

This is a massive topic for which there is no definitive answer unless one has a comprehensive knowledge of the problem(s) you are facing. You need to research terms such as "bind variable", "bind variable peeking", "adaptive cursor sharing", "cardinality feedback", and many more. But most important, you need to define the problem.

[Updated on: Wed, 05 March 2014 02:15]

Report message to a moderator