FCIS - Lock On FCTB_ONLINE_STATS Is Causing The App To Go Down
(Doc ID 2865612.1)
Last updated on NOVEMBER 01, 2022
Applies to:Oracle FLEXCUBE Investor Servicing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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
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