oracle table statistics last analyzed
SELECT ST.TABLE_NAME, ST.PARTITION_NAME, HIGH_VALUE, ST.NUM_ROWS, ST.BLOCKS, ST.LAST_ANALYZED FROM DBA_TAB_STATISTICS ST LEFT JOIN DBA_TAB_PARTITIONS PAR ON PAR.TABLE_NAME = ST.TABLE_NAME AND PAR.PARTITION_NAME = ST.PARTITION_NAME WHERE ST.OWNER = 'MY_OWNER' AND ST.TABLE_NAME = 'MY_TABLE' ORDER BY PARTITION_NAME;