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 JUNE 16, 2022

Applies to:

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

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