My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On HDR version,

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.

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.

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


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.