The Basel Batch Run Execution It's Taking Long Time.
(Doc ID 3036502.1)
Last updated on JULY 29, 2024
Applies to:
Oracle Financial Services Basel Regulatory Capital Basic - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
On: 8.1.2 Version, OFS_BASEL
The performance issues in our main BASEL run execution.
When executing the batch it's taking more time and the please find the below PR2 task.log.
LOG FILE
-----------------------
Filename = PR2 Task.log
See the following error:
[21-06-24 10:40:36,407 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] FINAL QUERY ::: MERGE INTO FSI_CAP_BANKING_EXPOSURES TT USING ( SELECT FSI_CAP_BANKING_EXPOSURES.N_ACCT_SKEY,FSI_CAP_BANKING_EXPOSURES.N_GAAP_SKEY,FSI_CAP_BANKING_EXPOSURES.N_RUN_SKEY,FSI_CAP_BANKING_EXPOSURES.N_CAP_APPROACH_TYPE_
[22-06-24 05:59:07,432 GMT AM] [DEBUG] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] FINAL QUERY with execution time :::
[22-06-24 05:59:07,439 GMT AM] [DEBUG] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] Query -> MERGE INTO FSI_CAP_BANKING_EXPOSURES TT USING ( SELECT FSI_CAP_BANKING_EXPOSURES.N_ACCT_SKEY,FSI_CAP_BANKING_EXPOSURES.N_GAAP_SKEY,FSI_CAP_BANKING_EXPOSURES.N_RUN_SKEY,FSI_CAP_BANKING_EXPOSURES.N_CAP_APPROACH_TYPE_
Time taken for query execution -> 69511016 milliseconds.
[22-06-24 05:59:07,441 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] PostScript ::: null
[22-06-24 05:59:07,442 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule]
[22-06-24 05:59:07,453 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] Number of rows affected ::: 237
[22-06-24 05:59:07,453 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] --------------------------------------------------------------------------
[22-06-24 05:59:07,454 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] ---End of Rule Execution Operations :Sat Jun 22 10:59:07 PKT 2024-----
[22-06-24 05:59:07,455 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] --------------------------------------------------------------------------
Changes
No 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 |