How you diagnose missing collect stats for a query?

Execute first  DIAGNOSTIC HELPSTATS ON FOR SESSION;

Then take explain plan- You can see at the end of explain plan if any stats pending to be collected.