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 get the past execution plan for a particular query ?

SuvvAug 31 2010 — edited Aug 31 2010

Suppose i have a query which used to run faster and after 15 days i found the query execution is very slow.Now i want to compare the present execution and past execution plan.Can someone guide me ..How can i extract (from what views/tables) the old plan execution plan...

As far my knowledge if ia know the sql_id ,We can get it from v$sql (Also AWR maintains history for the sql plan execution.)
What if i don't know the sqlID ?

Any help /hint is appreciated !

Regards
Suvv

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2010

Added on Aug 31 2010

#general-database-discussions

6 comments

1,872 views