Performance on Collection Import Quality Alert
(Doc ID 2515319.1)
Last updated on SEPTEMBER 29, 2023
Applies to:
Oracle Alert - Version 12.2.3 to 12.2 [Release 12.2]Oracle Quality - Version 12.2.3 to 12.2 [Release 12.2]
Information in this document applies to any platform.
Symptoms
For a simple SQL / PLSQL call it takes in average 40-50 seconds from the ALECDC is started till actually execute the first statement from the PLSQL. This is a big delay as for label printing is used and at the end the waiting time is 1-2-3 minutes to get the labels.
The goal is to get everything processed for less than 10 seconds.
-bash-3.2$ strings -a $ALR_TOP/bin/ALECDC | grep alssmn.lc
$Header: alssmn.lc 120.31.12020000.1 2012/07/02 11:02:01 appldev ship $
Changes
From the Collection form , QLTPLMDF.fmb, there are lots of
Action Sets created (1,168) which is being passed to the Periodic Alert program:
Quality Action Standard Alert.
This is causing performance issues.
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 |
References |