My Oracle Support Banner

OFSLL UAT - ORA-01555: Snapshot Too Old | Rollback Segment Rollback Segment (Doc ID 2860250.1)

Last updated on APRIL 02, 2022

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version 14.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
---------------

Please take care of the below issue in OFSLL UAT instance.

03/03/2022 SessionID=15392694 AppUser=INTERNAL OSUser=oracle

OFSLL Error Msg :

Ora Error Code : 1555

Ora Error Msg : ORA-01555: snapshot too old: rollback segment number 163 with name "_SYSSMU163_1556505585$" too small

Context : Error in : txnmdt_bj_100_01.txnmdt_bj_100_01

Context : Error in : jsvprc_en_000_01.run_procedure_job

Context : Error in : jsvprc anonymous plsql

 


EXPECTED BEHAVIOR
-----------------------
System performance should not have an impact

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run the Mock statement batch job

2. Verify the batch timings.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, end of the day is getting delayed

Changes

 

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


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