ORACLE: Show Statistic Updates

person Jason Huangfolder_openCode, Oraclelocal_offer, , , , , access_time March 17, 2016

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
3
FEB-02-2016
2
FEB-03-2016
3
FEB-04-2016
1
FEB-05-2016
2
FEB-08-2016
3
FEB-10-2016
1
FEB-11-2016
16
FEB-12-2016
2
FEB-16-2016
3
FEB-17-2016
1
FEB-18-2016
1
FEB-19-2016
3
FEB-25-2016
3
FEB-26-2016
7
FEB-29-2016
3
JAN-08-2016
368
JAN-17-2016
15
JAN-19-2016
5
JAN-20-2016
7
JAN-22-2016
3
JAN-25-2016
1
JAN-26-2016
3
JAN-27-2016
2
JAN-28-2016
1
JAN-29-2016
1
MAR-01-2016
1
MAR-02-2016
9
MAR-04-2016
6
MAR-05-2016
4
MAR-07-2016
6
MAR-08-2016
6
MAR-09-2016
4
MAR-10-2016
5
MAR-11-2016
4
MAR-14-2016
5
MAR-15-2016
2
MAR-16-2016
18

38 rows selected.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>