My Oracle Support Banner

Saving A Specifc Study In RDC Onsite Test Mode Is Extremely Slow (Doc ID 1397298.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.3 and later   [Release: 4.5.3 and later ]
Information in this document applies to any platform.

Goal


In RDC Onsite test mode, saving a specific study is extremely slow.

The following query has been identified as the root of the problem:

SELECT 1
FROM
RECEIVED_DCIST RDCI, RECEIVED_DCMST RDCM, RESPONSEST R WHERE
RDCI.RECEIVED_DCI_ID = :B1 AND RDCI.END_TS = TO_DATE(3000000,'J') AND
RDCM.RECEIVED_DCI_ID = RDCI.RECEIVED_DCI_ID AND RDCM.END_TS =
TO_DATE(3000000,'J') AND R.RECEIVED_DCM_ID = RDCM.RECEIVED_DCM_ID AND
R.END_TS = TO_DATE(3000000,'J') AND NVL
(VALUE_TEXT,EXCEPTION_VALUE_TEXT) IS
NOT NULL


Is this a set up issue or a bug?

Solution

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
  Goal
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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