Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Cursor_sharing


Setting the cursor_sharing to either similar or force allows similar statements to share SQL area.
The difference between similar and force is that similar forces similar statements to share SQL area without deteriorating execution plans.
Setting cursor_sharing to force forces similar statements to share the executable SQL area, potentially deteriorating execution plans. Hence, force should be used as a last resort, when the risk of suboptional plans is outweighting by the improvements in cursor sharing.
==>deteriorating=changing
Related Posts Plugin for WordPress, Blogger...

Flag Counter