Slowness Due to Row Lock Contention on Hostauditlog Table.
(Doc ID 2711002.1)
Last updated on DECEMBER 04, 2020
Applies to:Oracle FLEXCUBE Direct Banking - Version DB 12.0.2 to DB 12.0.2 [Release DB 12]
Information in this document applies to any platform.
Row lock contention is found for below query in ASH (Active Session History) reports while updating the host audit logging data:
update hostauditlog set error_code = :1 , error_desc = :2 , status = :3 , execution_end_time = :4 where idseq = :5
There should not be a row lock contention for updating the host audit logging data.
This is a performance issue and can be reproduced if Hostauditlog table has huge data (records in lakh) and concurrent user count is high (in thousands):
1. Login into FCDB application using retail/corporate user.
2. Perform funds transfer transaction.
3. Observe the slowness on 'Confirm' screen.
4. Extract ASH report and check for the 'update hostauditlog .. ' query.
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