exec DBMS_STATS.GATHER_DATABASE_STATS;

[ggnanaraj]

Originally posted by Orca777

SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);

Correction...

SELECT count(*) from dba_tables dt where dt.last_aNalyzed > TRUNC(SYSDATE);

HTH.