My Oracle Support Banner

LSH Job Queue is Starting Very Slowly (Doc ID 1472962.1)

Last updated on OCTOBER 10, 2019

Applies to:

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

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.2.0.3 version,

ACTUAL BEHAVIOR  
---------------
LSH Job Queues are hanging again and again and responding very slowly.
If restarting the Job Queues, it takes a very long time to restart.
The restart that was issued last night came in the log this morning.
If trying to restart after that it takes about 7-8 hours to accomplish this task.

EXPECTED BEHAVIOR
-----------------------
Expected that the LSH Job Queues to respond faster.

STEPS
-----------------------
The issue can be reproduced with following steps:
1. Start the LSH Jobs Queue:
begin
cdr_exe_job_queues.start_jobq_process_disabled;
end;
/
commit;
2. Enable the LSH Jobs queue:
begin
cdr_exe_job_queues.start_jobq_process_enabled;
end;
/
commit;

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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