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!

Find the old sql plan and check how many times it has changed

$phinx19Mar 31 2017 — edited Apr 2 2017

Hi All,

OS: RHEL

DB:11gR2

We need to find the sql plan for a bad query and check if it is using a new plan. I tried google but it is not helping.

Is there a query for the same.\

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2017

Added on Mar 31 2017

#general-database-discussions

11 comments

7,205 views