Checking staistics history on table
COL TABLE_NAME FORMAT a10SELECT TABLE_NAME, TO_CHAR(STATS_UPDATE_TIME,'YYYY-MM-DD:HH24:MI:SS') AS STATS_MOD_TIMEFROM DBA_TAB_STATS_HISTORY WHERE TABLE_NAME='ORDERS'AND OWNER='OE'ORDER BY STATS_UPDATE_TIME DESC;Restore Table statistics
BEGIN DBMS_STATS.RESTORE_TABLE_STATS( 'OE','ORDERS', TO_TIME...