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.

Complete Database Performance Management