ORA-01555 snaphot too old from SQL on small table

   I received the following error in my alert.log:

ORA-01555 caused by SQL statement below (SQL ID: av96dcjunv52g, Query Duration=15017 sec, SCN: 0x0004.d3a4b1db):

 

I was able to track down the SQL ID via OEM but there was no stats/parsing user information attached to it.  Though the table it is selecting from is only a few MB in size.  I'm puzzled how this error could have happened from SQL on such a small table.

 

SQL stmt was:

SELECT STYLE_NBR,GRID_NBR,BRAND,STYLE_NAME,BGRP,CLASS,ONHAND_2,CURR_UNITS_2,CURR_MARGIN_2,LASTWK_UNITS_2,SELL_THRU_2,STD_UNITS_2,STD_MARGIN_2,ROLL_UNITS_2,LAST_SEA_UNITS_2,QTY_ORD_2,LAST_RECEIPT_DATE_2 FROM (select style_nbr, grid_nbr, brand,