My Oracle Support Banner

Mass Change Performance Extremely Slow (Doc ID 2439788.1)

Last updated on FEBRUARY 10, 2019

Applies to:

Oracle Clinical - Version 5.1.0 and later
Information in this document applies to any platform.

Symptoms

ISSUE:
-------
Bad performance Validating a Mass Change.   TKPROF reports the sql with the issue is:

 

SELECT 1
FROM
 RESPONSES RESP , MC_CANDIDATE_DATA CDR WHERE RESP.CLINICAL_STUDY_ID = :B3
  AND RESP.END_TS = TO_DATE ( '3000000','J') AND CDR.MC_CANDIDATE_DATA_ID =
  :B2 AND RESP.RESPONSE_ID = DECODE ( :B1 ,1,CDR.RESPONSE_ID1 ,2,
  NVL(CDR.RESPONSE_ID2,RESP.RESPONSE_ID) ,3,NVL(CDR.RESPONSE_ID3,
  RESP.RESPONSE_ID) ,NVL(CDR.RESPONSE_ID4,RESP.RESPONSE_ID) )

 

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.