DBA Scheduler Job For Database Purging Has Stopped Working
(Doc ID 2898163.1)
Last updated on SEPTEMBER 29, 2022
Applies to:
Oracle FLEXCUBE Direct Banking - Version DB 12.0.3 to DB 12.0.3 [Release DB 12]Information in this document applies to any platform.
Symptoms
If we check the output of below query the FAIL_REASON column shows error as- ERROR- ORA-01555: snapshot too old: rollback segment number 123 with name "_SYSSMU123_3670071447$" too small
select * from purge_duration ;
Changes
No changes in the environment.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |