My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.