My Oracle Support Banner

FCIS - Lock On FCTB_ONLINE_STATS Is Causing The App To Go Down (Doc ID 2865612.1)

Last updated on MAY 01, 2022

Applies to:

Oracle FLEXCUBE Investor Servicing - Version 14.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms



While doing stress testing, 1000 sessions are created in parallel and below Update statement is locked
Below table belong to SMS schema
UPDATE FCTB_ONLINE_STATS SET MAXRESP = :1 ,MINRESP =:2 ,AVGRESP= :3 ,COUNT =:4 , LOGTIME=to_date(:5 ,:"SYS_B_0") WHERE FUNCTIONID = :6 AND ACTION = :7 AND SOURCE = :8
 



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
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.