My Oracle Support Banner

Performance Issues when Running a High Number of Jobs (Doc ID 2822416.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Oracle Life Sciences Data Hub - Version 3.1.0 and later
Information in this document applies to any platform.


On Oracle Life Sciences Data Hub (LSH) after upgrade from version 2.3 to 3.1,
there were observed performance issues when running a load testing with a high
number of jobs (500 PL/SQL jobs submitted at the same time).

Steps to Reproduce
1. Increase the number of PL/SQL service instances to 500.
2. Submit 500 PL/SQL jobs to run at the same time.
3. Submit a Work Area install while all jobs are still running.
When performing a Work Area install, the install log is listing a delay of
about 9 minutes between the following steps:


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

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