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 184.108.40.206.0 and later
Information in this document applies to any platform.
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:
'ORA-01555: snapshot too old: rollback segment number 49 with name "_SYSSMU49_3613974368$" too small'
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