Hi - I would like to know if it is possible to save (in a plan table, say) the real execution plan of a given SQL present in the SQL cache and later show it via DBMS_XPLAN - first please note, I´m talking about the real execution plan (and including the extentded stats such as A-ROWS and E-ROWs), not the estimatives from EXPLAIN PLAN : for EXPLAIN PLAN we know it is possible....
As far as I know, the only possibility here would be save the content of the related views (ie, V$SQL, V$SQL_PLAN, V$SQL_PLAN_STATISTICS_ALL) in my own custom tables and later write a query to assemble the plan.. NO other alternatives, maybe some built-in ?

Regards,

J. laurindo Chiappa

set serveroutput off

select /*+ gather_plan_statistics */* 
from   t;

select * 
from   table(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST'));