Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 11 2007 - 08:05:03 CDT
![]() |
![]() |