Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2006
    Posts
    15

    Unanswered: ORA-01555: snapshot too old: rollback segment number 5 ... too small

    Please help out!
    We've been getting this error when the imports are done to the database, 8i. To resolve this yesterday I added two more redo files, with 1GB size each. However I'm still getting this error. What else should I be looking at???

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Ask your users to STOP working while you are exporting or use parameter CONSISTENT=NO.

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    If its on import then you can use commit=10000 (i.e commit every 10000 records). Also adding redo logs wont help rollback errors, try increasing the size of the tablespace holding your rollback segments.

    Alan

  4. #4
    Join Date
    Jan 2006
    Posts
    15
    I can't change the import script since it's part of the software
    and I don't have access to it. Also, I can't stop users from working
    while the import is running. The import script is part of the cron job running every 15 minutes,
    and thus does it whenever it finds files in a certain folder.

    I added yesterday two more rollback segments, thus increasing the size of the tablespace:

    alter tablespace RBS ADD datafile '.../ora8/rbs07.dbf' SIZE 1024M;

    Yet we got the same error later on...

  5. #5
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    OK select * from dba_rollback_segs and check the extent sizes and max extents, it could be you have very small extents or a small max number of extents. You can also see whats using the rollback segs by querying v$transaction and looking at used_ublk for the number of blocks used. Then you can trace back to v$session and take some action against the offending session possibly.

    Alan

Posting Permissions

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