My Oracle Support Banner

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.


On : 9.2 version, Other

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.

Should take less time.



To view full details, 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 a vibrant support community of peers and Oracle experts.