Historical Plan & Time

Hello.

I have found that, the following sql is very helpful in finding out the
historical (What is in AWR) plan of a given SQL_ID.

select * from table (sys.dbms_xplan.display_awr('&Your_SQL_ID')) ;

But so far I could not figure out, how I can figure out WHEN this plan was
in effect. Is there a way, I can corelate this plan to Sysdate or in other
words, find out when this plan was in effect?

Thanks for your insight,
Shiva

Other related posts: