Historcal SQL Execution Plan Usage
SELECT sql_text from dba_hist_sqltext where
sql_id = '<SQLID Here>';
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_AWR('<SQLID Here>','<Plan Hash Value Here>',null,'ALL +OUTLINE'));
Download Speedway to format and display the results of the above scripts.
