Purge Debug Log And System Alerts Performance Issues (Doc ID 332103.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle Applications Manager - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Oracle Concurrent Processing - Version 12.2.5 to 12.2.5 [Release 12.2]
Oracle Application Object Library - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.
Oracle Application Object Library - Version: 11.5.10 to CU1

Symptoms

The FNDLGPRG Purge Debug Log program is experiencing the following:

Program is consuming CPU and taking a long time to complete
Query on table fnd_log_messages is consuming a lot of time

This problem began after applying 11.5.10 CU1.

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

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