www.oracle-wiki.net SQL Library
-- -- Get Historical Plans from the Cursor Cache Using SQLID -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR( SQL_ID=>'&SQLID', -- CHILD_NUMBER=>the_child_number, FORMAT=>'ALLSTATS LAST ALL +OUTLINE')) /