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

Last updated on JUNE 21, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms