ORA-01555: snapshot too old: rollback segment number N with name "X" too small | Community
Skip to main content
L
LAR1985
Level 3
September 2, 2025
Solved

ORA-01555: snapshot too old: rollback segment number N with name "X" too small

  • September 2, 2025
  • 1 reply
  • 987 views

Hello community,

 

We are experiencing the following issue: occasionally, when running workflows, we get the following error in some deliveries "ORA-210000 Oracle error: ORA-01555: snapshot too old: rollback segment number N with name "X" too small". These are isolated errors that do not happen always in the same workflows and always work when re-run. What could be causing this?

 

Thanks

 

Best answer by Rch_

Hi @lar1985,

 

This error usually happens when a workflow is running a query that takes a long time, and the database can’t keep up with all the changes happening at the same time. Because of that, some data it needs gets cleaned up too soon.

Since it only happens sometimes and works when you try again, it’s likely due to the database being busy or having limited space for temporary data.

A few things that can help:

  • Ask your DBA to give more space for undo data and keep it longer.

  • Try running big workflows during quieter times.

  • Break big workflows into smaller parts if you can.

  • Look at how complex your queries are and try to simplify them.

Hope that helps! Feel free to ask if you want tips on checking your workflows.

 

Thanks,

1 reply

Rch_
Rch_Accepted solution
Level 3
September 2, 2025

Hi @lar1985,

 

This error usually happens when a workflow is running a query that takes a long time, and the database can’t keep up with all the changes happening at the same time. Because of that, some data it needs gets cleaned up too soon.

Since it only happens sometimes and works when you try again, it’s likely due to the database being busy or having limited space for temporary data.

A few things that can help:

  • Ask your DBA to give more space for undo data and keep it longer.

  • Try running big workflows during quieter times.

  • Break big workflows into smaller parts if you can.

  • Look at how complex your queries are and try to simplify them.

Hope that helps! Feel free to ask if you want tips on checking your workflows.

 

Thanks,

Terms & ConditionsAccessibility statement

Loading footer...