Exterme slowness in an LSH Data Load (Doc ID 2259760.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 to 2.4.6 [Release 2.4]
Information in this document applies to any platform.

Symptoms

A data load into to LSH is currently in progress as part of Data migration activities and the issue is the LSH Public API execution responsible for the creation of load sets, table instances, descriptors etc, is running extremely slow.
You've confirmed there's no issue in the Database. The results of running the following queries below seem acceptable.

a).
SELECT OWNER, TABLE_NAME, TO_CHAR(last_analyzed, 'yyyy/mm/dd hh:mi:ss am') AS
last_analyzed
FROM all_tables
where OWNER in (UPPER('APPS'), UPPER('CDR'), UPPER('OWBSYS'))
order by owner;

b).
select OWNER,TABLE_NAME,LAST_ANALYZED,STALE_STATS from DBA_TAB_STATISTICS
where STALE_STATS='YES';

You've reviewed the AWRs and believe that 90% of the queries are from the out of the box LSH API as opposed to custom code e.g. you've confirmed where the long running query below is running from, that it's not in custom code. As per AWR.

"90ndt4mfsuhdsSELECT MAX(NMV.OBJ_VER) FROM
CDR_NAMING_VERSIONS NMV WHERE NMV.COMPANY_ID = :B2 AND NMV.OBJ_ID = :B1 " is
executing.

 

Cause

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 hundreds of Community platforms