SELECT T1.SQL_ID, T1.CHILD_NUMBER, T1.SQL_TEXT FROM V$SQL T1 WHERE T1.SQL_TEXT LIKE '%GATHER_PLAN_STATISTICS%' ORDER BY T1.LAST_ACTIVE_TIME DESC;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('SQL_ID',CHILD_NUMBER,'ALLSTATS LAST'));