Skip to Main Content

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!

Reg: Cardinality Feedback for queries having bind variables

Madhu.149Dec 26 2013 — edited Dec 27 2013

Hello All,

One of my query (having no bind variables) is taking long time(10 minutes) to execute for second execution.

I came to know that its because of Cardinality feedback.

I disabled _optimer_use_feedback by using hint and the query was executed within 2 seconds.

If I disable _optimizer_use_feedback at instance level, is there any problem for the queries having bind variables?

This post has been answered by Girish Sharma on Dec 27 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2014
Added on Dec 26 2013
9 comments
531 views