This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,715 Users
  • 2,269,776 Discussions


Change the ORA-1555 message

Franck Pachot
Franck Pachot OCM 12c DBA Oracle ACE Director and Oak Table memberSwitzerlandMember Posts: 912 Bronze Trophy
edited Jan 11, 2016 6:19PM in Database Ideas - Ideas

A very simple idea: please change the message for ORA-1555: snapshot too old: rollback segment number ... with name "..." too small

How many times a user receiving this message just blame the DBA for putting too small rollback segments!

Message should be: query duration beyond undo retention, can't get consistent view.

Franck PachotNiall LitchfieldKim Berg Hansenuser7328662ctriebtop.gunberxBeGinBPeaslandDBAWilliam RobertsonPravin TakpireLothar FlatzZlatko SiroticMartin PreissMartin Lutzuser12218407sysassysdbaChris Huntmbe7Sven W.mtefftApexBineMelody S-Oracle1483608N.B.user7048955Hemant K ChitaleUser_F2Y1CGregVDaniel HillingerAndreas Huber1244776Gerald Venzl-OraclegassenmjMr. CEmad Al-Mousauser3623132opentuningsMohammed Sulaimanfloo_barFamilyGuy81User_9GEWMuser10285Billy VerreynneUser_S1J6PCherif bhPeterGJose Carlos Pavón
49 votes

Active · Last Updated


  • Pravin Takpire
    Pravin Takpire Technical Manager BangaloreMember Posts: 1,770 Gold Trophy

    really, it is required. DBA's only can understand pain.



    Franck Pachot
  • Lothar Flatz
    Lothar Flatz Member Posts: 687 Silver Badge

    I like the old message for no good reason, just nostalgia. In spite of that I think you are right.

    Franck PachotApexBineGbenga Ajakaye
  • William Robertson
    William Robertson London, UKMember Posts: 9,579 Bronze Crown

    The reference to a named rollback segment assumes manual undo management which has been deprecated since 9i so the message is confusing from the start, never mind that it misleadingly gives developers the impression that they should save undo space with smaller transactions.

    Franck PachotUser51642 Yong Huang
  • Martin Lutz
    Martin Lutz Member Posts: 28

    I'm voting for a change, too. But do you think the suggested new message will keep users from complaining or prevent user-misunderstandings?

    Maybe we can collect some more suggestions, similar to the one you provided, and try to improve the message (not requesting this to be the best one):

    "Query exceeds consistency limit"

    Franck PachotCherif bh
  • GKris
    GKris Mr New JerseyMember Posts: 11

    May be good time to re-visit all such Messages to suit today's usage.


    Phani G Kris

  • Gbenga Ajakaye
    Gbenga Ajakaye IT Consultant Member Posts: 3,422 Gold Trophy

    Even better - add the name of the table or index whose block could not be reconstructed!

    This is a great addition and I think would make our job easier.

  • mtefft
    mtefft Member Posts: 852 Gold Badge

    Even better - add the name of the table or index whose block could not be reconstructed!

    I have had a bunch of ORA-1555 issues to investigate recently so I wanted to bubble this up again.

    Please modify the message to include the name of the table or index whose block could not be reconstructed.

    This information is key to any possible analysis or correction. Without it, we have to rely on guesses.

    My current issue has 61 steps in the execution plan, using 22 tables. It is a batch process that failed after 4 hours. I try to find possible 'interfering' SQL in a reasonable timeframe in ASH, that might have hit one of the tables used in this query. No smoking gun.

    If I knew which of the 22 tables had a block that could not be reconstructed, I can focus my investigation and have a much stronger argument for prioritizing changes needed to prevent recurrence.

    Jose Carlos Pavón
  • connor_mc_d-Oracle
    connor_mc_d-Oracle Connor McDonald Posts: 88 Employee
    edited Nov 12, 2022 1:33PM

    This error message (and many others) is being improved in 23c

    (Standard safe harbour applies, what you see in the 23c beta release may or may not end up production etc)

    Franck PachotCherif bh