Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Historical Plan & Time

Historical Plan & Time

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Mon, 11 Jun 2007 09:05:03 -0400
Message-ID: <1e52ad820706110605g5d5d7615g110955f5cf347379@mail.gmail.com>


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-l
Received on Mon Jun 11 2007 - 08:05:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US