My Oracle Support Banner

On SaaS Troubleshooting ORA-01555: snapshot too old: rollback segment number ... too small And ORA-01652: Unable to extend temp segment in FUSION_TEMP (Doc ID 2519836.1)

Last updated on JUNE 30, 2020

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Goal

When a customer reports:

ORA-01555: snapshot too old: rollback segment number 102 with name "_####_####$" too small

on Cloud SaaS BIP Environment, we need to check to see if the customers FUSION Undo Tablespace has enough space.

Also, the following solution will work for when a report fails with ORA-01652: unable to extend temp segment in FUSION_TEMP

Example: One report ran for very long time (25 hours) and failed with error message:

ERROR
-----------------------
'ORA-01555: snapshot too old: rollback segment number 49 with name "_SYSSMU49_3613974368$" too small'

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.