analyze table

ANALYZE TABLE schemaname.tablename ESTIMATE STATISTICS
/

find whether a table is analyzed or not

SELECT OWNER, TABLE_NAME, NUM_ROWS, LAST_ANALYZED FROM DBA_TABLES WHERE TABLE_NAME='tablename' AND OWNER='ownername'
/