Snapshot too old on 9i (9.1.2) - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Snapshot too old on 9i (9.1.2)

  1. #11
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by julian
    The bigger the retention period, the more commited information needs to be kept in the undo segments. Thus the chance for Oracle to overwrite such commited transactions grows. If such info is overwritten, then ORA-01555 will be raised. That's OK as this is just a warning.
    Julian,
    Allow me to disagree here. The bigger the UNDO_RETENTION lesser the chances of getting OOA-1555 provided your UNDO_TABLESPACE is big enough to support that retention period. If the undo tablespace size is not enough to support the retention period then the trnasactions will be overwritten.
    Reducing UNDO_RETENTION will not help getting rid of ORA-1555

    A couple of Notes I found on metalink regarding this are here.
    http://metalink.oracle.com/metalink/..._id=347348.996
    http://metalink.oracle.com/metalink/..._id=470293.999
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  2. #12
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Originally posted by SANJAY_G
    [B]The bigger the UNDO_RETENTION lesser the chances of getting OOA-1555 provided your UNDO_TABLESPACE is big enough to support that retention period. If the undo tablespace size is not enough to support the retention period then the trnasactions will be overwritten.
    Reducing UNDO_RETENTION will not help getting rid of ORA-1555
    This is how I understood it as well.
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width