Skip to Main Content

SQL & PL/SQL

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=similar

GTS (DBA)Aug 23 2013 — edited Aug 25 2013

Hello Experts ;

I don't understand what i marked as bold following term.

SIMILAR causes statements that may differ in some literals, but are otherwise identical, to share a cursor,

unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.

Can i get any simple example for  ( degree to which the plan is optimized )  ?


Thanks !

This post has been answered by SomeoneElse on Aug 23 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2013
Added on Aug 23 2013
13 comments
410 views