ORA-01555 caused by SQL statement below (Query Duration=16490 sec, SCN: 0x0000.3568c0aa):
Tue Jul 21 18:05:14 2009
UPDATE AUD_SUBJECTIVE_PRM_TRANS AUDT SET AUDT.USER_ID = :V00001, AUDT.TRANS_DATETIME = SYSDATE WHERE AUDT.ID = :V00002 AND AUDT.DBACTIONTYPE = :V00003
Tue Jul 21 18:05:14 2009
Errors in file c:\oracle\admin\imacs\udump\imacs_ora_7156.trc:
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small




show parameter undo_retention

name                      value
---------              ---------------

undo_retention           10800