Oracle Flashback features will give you transaction information ( if you are in 10g) within UNDO_RETENTION period.