My Oracle Support Banner

LSH: Clone Operation Inside LSH Taking a Long Time (Doc ID 2435276.1)

Last updated on AUGUST 20, 2018

Applies to:

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

Symptoms

LSH 2.4.7, you notice slow performance when doing a CLONE operation inside LSH. The problem SQL Id and statement is:

SQL ID: cxp6f9nd21wy2

SELECT PR.COMPANY_ID COMPANY_ID,
  PR.SRC_PAR_REF_OBJ_ID SRC_PAR_REF_OBJ_ID,
  PR.SRC_PAR_REF_OBJ_VER SRC_PAR_REF_OBJ_VER,
  PR.TGT_PAR_REF_OBJ_ID TGT_PAR_REF_OBJ_ID,
  PR.TGT_PAR_REF_OBJ_VER TGT_PAR_REF_OBJ_VER,
  PR.RELATION_TYPE RELATION_TYPE,
  SRC_NM.NAME SRC_PAR_NAME,
  TGT_NM.NAME TGT_PAR_NAME,
  PR.SRC_PARENT_OBJ_ID SRC_PARENT_OBJ_ID,
  PR.SRC_PARENT_OBJ_VER SRC_PARENT_OBJ_VER,
  NVL (
  CDR_RS_REPORT_SET_ENTRY.
  GETTITLE (PR.COMPANY_ID,
  PR.SRC_PARENT_OBJ_ID,
  PR.SRC_PARENT_OBJ_VER),
  SRC_PARENT_NM.NAME)
  SRC_PARENT_NAME,
  PR.TGT_PARENT_OBJ_ID TGT_PARENT_OBJ_ID,
  PR.TGT_PARENT_OBJ_VER TGT_PARENT_OBJ_VER,
  NVL (
  CDR_RS_REPORT_SET_ENTRY.
  GETTITLE (PR.COMPANY_ID,
  PR.TGT_PARENT_OBJ_ID,
  PR.TGT_PARENT_OBJ_VER),
  TGT_PARENT_NM.NAME)
  TGT_PARENT_NAME
  FROM CDR_PARAMETER_RELATIONS PR,
  CDR_NAMINGS SRC_NM,
  CDR_NAMINGS TGT_NM,
  CDR_NAMINGS SRC_PARENT_NM,
  CDR_NAMINGS TGT_PARENT_NM
WHERE PR.COMPANY_ID = SRC_NM.COMPANY_ID
  AND PR.SRC_PAR_REF_OBJ_ID = SRC_NM.OBJ_ID
  AND PR.COMPANY_ID = TGT_NM.COMPANY_ID
  AND PR.TGT_PAR_REF_OBJ_ID = TGT_NM.OBJ_ID
  AND PR.COMPANY_ID = SRC_PARENT_NM.COMPANY_ID
  AND PR.SRC_PARENT_OBJ_ID = SRC_PARENT_NM.OBJ_ID
  AND PR.COMPANY_ID = TGT_PARENT_NM.COMPANY_ID
  AND PR.TGT_PARENT_OBJ_ID = TGT_PARENT_NM.OBJ_ID
  AND PR.COMPANY_ID = :B3
  AND SRC_PAR_REF_OBJ_ID = :B2
  AND SRC_PAR_REF_OBJ_VER = :B1
UNION
SELECT PR.COMPANY_ID COMPANY_ID,
  PR.SRC_PAR_REF_OBJ_ID SRC_PAR_REF_OBJ_ID,
  PR.SRC_PAR_REF_OBJ_VER SRC_PAR_REF_OBJ_VER,
  PR.TGT_PAR_REF_OBJ_ID TGT_PAR_REF_OBJ_ID,
  PR.TGT_PAR_REF_OBJ_VER TGT_PAR_REF_OBJ_V


o Runs a long time
o Behavior happens often and usually when you need to promote from one life cycle to another one.


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!


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