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!

sql plan changes

user353062Jul 4 2012 — edited Jul 4 2012

Hi,

Can any one please tell me the view that can be used to find the changes the plans (hash_value,plan_hash_value for a particular sql statement).

I have a particular sql statement for which the execution plan changes but, unfortunately i cannot find regarding which view can be used to find the details regarding this. V$SQL_PLAN_MONITOR is not helping as well.

Thanks,
+Violet

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2012

Added on Jul 4 2012

#general-database-discussions

4 comments

136 views