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!

Optimizer picking up bad query plan

Gaurishankar PatleJul 10 2015 — edited Jul 13 2015

We had an issue in production database which is Oracle 11gR2 - 11.2.0.4.0. Users started complaining about the slow running queries and we found out a particular SQL as TOP SQL impacting performance. Upon running the SQL Profile on this query that used to be taking 467 Seconds to execute started getting run in .277 seconds.

Why and when the optimizer started bad plan for this particular SQL and how can we find out what triggered the optimizer pick up the bad plan.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2015

Added on Jul 10 2015

#general-database-discussions, #performance

3 comments

1,269 views