My Oracle Support Banner

Performance Issue On Learning Environment Component With Large Amount Of Courses (Doc ID 2147549.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

ACTUAL BEHAVIOR
---------------
Performance issue on Learning environment component with large amount of courses

In the LM_LE_CMP (Learning environment) component we encounter a performance issue. The LM_LE_REL_PG (Security) page contains 12k+ records in the Courses section. For each of these entries the PS_LM_CI_PT table is queried separately. This takes about 17-18 seconds, which is not acceptable for the client.

EXPECTED BEHAVIOR
-----------------------
Should take less time.

 

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
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.