To analyze the TABLES/INDEXES of a schema at one stroke

EXEC DBMS_STATS.GATHER_SCHEMA_STATS(USER,CASCADE=>TRUE);

Are the tables/indexes are being analyzed or not?

SELECT TRUNC(LAST_ANALYZED),COUNT(1) FROM DBA_TABLES

WHERE OWNER='DOTSOFT'

GROUP BY TRUNC(LAST_ANALYZED);

SELECT TRUNC(LAST_ANALYZED),COUNT(1) FROM DBA_INDEXES

WHERE OWNER='DOTSOFT'

GROUP BY TRUNC(LAST_ANALYZED);