Excessive Time Spent Querying HCT_ET_LOCAL_DESC with Zero Results Returned

(Doc ID 2273132.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Healthcare Data Repository - Version 7.0.1.7 and later
Information in this document applies to any platform.

Symptoms

On HDR 7.0.1.7 version,

ACTUAL BEHAVIOR
---------------
During performance testing for the latest Meds View it was discovered that there is a big amount of time being wasted in the middle tier looking up data in HCT_ET_LOCAL_DESC table.

This table does not contain any data and the query itself is fast at the database level, however due to the number of such calls and the network time for each of them, the total transaction time increases quickly and unnecessarily.

EXPECTED BEHAVIOR
-----------------------
It would be expected that this query on HCT_ET_LOCAL_DESC table not to be generated.
There is a considerable amount of time wasted during this process.

STEPS
-----------------------
The issue can be reproduced in Customer's environment the following steps:
1. Perform a MEV generation of a 2000 document view.


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