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!

How to check previous plan hash value in oracle standard edition

Anand YadavMay 24 2019 — edited May 25 2019

Hi,

We are running our database on oracle 12.1.0.2 standard edition.

Suddenly performance degraded for a DELETE statement without any change. I suspect that query plan got changed but not sure how to identify what was previous plan.

When I looked statspack reports for good and bad run, I can see only query old_hash_value. But it remains same.

Is there a way to check what execution plan it was using before plan change?

This post has been answered by Kazuhiro on May 25 2019

Jump to Answer

Added on May 24 2019

#general-database-discussions

6 comments

3,003 views