Query DBA_HIST_WR_CONTROL to see the interval, retention and the TOPNSQL setting. For TOPNSQL a setting of DEFAULT translates to:
30 where statistics_level is typical
100 where statistics_level is all
Simply because this one SQL appears to consume 7% of the load it may not be in the top SQLs in these categories:
If the SQL doesn’t make the ‘cut’ it isn’t saved and statistics aren’t collected.
Ref: David Fitzjarrell from Oracle community group