Get Historical Plans from the AWR Using SQLID
--
-- Get Historical Plans from the AWR Using SQLID
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT * FROM TABLE(dbms_xplan.display_awr('&SQL_ID'))
/

Related Scripts

List Distinct SQL ID's for a Given Session
Displays SQL Statement for the Specified Address or Hash
List SQL Run Dates for a Given Plan Hash Value

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License