ROLLBACK SEGMENT ERROR ORA-01555:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ROLLBACK SEGMENT ERROR ORA-01555:

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    Hi ,

    I get this error

    ORA-01555: snapshot too old: rollback segment number 12 with name "RBS13" too small.

    We have commit in the program for every 200 record.

    What is the solution..?

    SK Das


  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Make your rollback segments bigger OR commit for every 100 or 50 records.

    You can take care of OPTIMAL parameter for your RB segments if its not set. Check out the docs.
    Reddy,Sam

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    make commit less often

    higher minextents

    larger extent size

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Also you can increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

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