undo retention should be set to higher then the single longest running query. Set your undo tablespace size appropriately