Exterme slowness in an LSH Data Load
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.
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.
SELECT OWNER, TABLE_NAME, TO_CHAR(last_analyzed, 'yyyy/mm/dd hh:mi:ss am') AS
where OWNER in (UPPER('APPS'), UPPER('CDR'), UPPER('OWBSYS'))
order by owner;
select OWNER,TABLE_NAME,LAST_ANALYZED,STALE_STATS from DBA_TAB_STATISTICS
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
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