Performance on Collection Import Quality Alert
(Doc ID 2515319.1)
Last updated on APRIL 23, 2021
Applies to:Oracle Alert - Version 12.2.3 to 12.2.8 [Release 12.2]
Oracle Quality - Version 12.2.3 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
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 $
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.
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