Home » RDBMS Server » Server Administration » Error in Alert Log (Oracle 9i)
Error in Alert Log [message #414973] Fri, 24 July 2009 04:02 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I got an error in the alert log


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



Please help to resolve the above issue?

Regards

[EDITED by LF: specified product version]

[Updated on: Fri, 24 July 2009 04:20] by Moderator

Report message to a moderator

Re: Error in Alert Log [message #414981 is a reply to message #414973] Fri, 24 July 2009 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.lmgtfy.com/?q=oracle+1555

Regards
Michel
Re: Error in Alert Log [message #419134 is a reply to message #414973] Thu, 20 August 2009 00:42 Go to previous messageGo to next message
russmart
Messages: 5
Registered: August 2009
Junior Member
Had the same issue today. Thanks!
Re: Error in Alert Log [message #419146 is a reply to message #419134] Thu, 20 August 2009 01:19 Go to previous message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you can apply the same answer.

Regards
Michel

[Updated on: Thu, 20 August 2009 01:19]

Report message to a moderator

Previous Topic: ORA-03113: end-of-file on communication channel (merged)
Next Topic: High Undo tilization by CJQ0 (merged 5)
Goto Forum:
  


Current Time: Mon Dec 05 05:08:10 CST 2016

Total time taken to generate the page: 0.06744 seconds