My Oracle Support Banner

When using Oracle Learning Management multiple DB Sessions Are Created Causing A Performance issue While Trying to Play the Content. (Doc ID 2399708.1)

Last updated on MAY 16, 2018

Applies to:

Oracle Learning Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
------------------------------
When OLM users tried to search and play the course , All the 4 node RAC database servers exhausted all of the memory and got into a hung state . This is can be reproduced with 200 uses in Test instance too.

EXPECTED BEHAVIOR
--------------------------
 OLM should not exhaust all the memory in the DB.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Issue could reproduced in a test system with just 200 users. We noticed that LMS users generated almost 2500 DB sessions and processes and because of this all the DB nodes ran out of memory .


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!


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