ORACLE: Show Statistic Updates

The following Oracle SQL command allows you to see the statistics information, grouping by the last analyzed date (the is the name of schema you need to substitute into the SQL query: select to_char(last_analyzed,’MON-DD-YYYY’), count(*) from dba_tables where owner=” group by to_char(last_analyzed,’MON-DD-YYYY’) order by to_char(last_analyzed,’MON-DD-YYYY’); The output looks like this: TO_CHAR(LAST_ANALYZED,’MON-DD-YYYY’) —————————————————————————— COUNT(*) ———- FEB-01-2016 […]