My Oracle Support Banner

In OHF 7.1.1, HCD Incremental Views Run Too Slowly (Doc ID 2513706.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Healthcare Foundation - Version 7.1.1 to 7.2.1 [Release 7.1 to 7.2]
Information in this document applies to any platform.

Symptoms

On : OHF 7.1.1 to OHF 7.2.1 version, Performance

ACTUAL BEHAVIOR
---------------
During the daily load plan, HCD Incremental Views "HCD.V_ENC_PROC_FB_INCR (60 mins - 71993 rows), HCD.V_SUBST_ADMIN_FB_INCR (170 mins - 19339 rows) and HCD.V_ENC_DIAG_FB_INCR (50 mins - 45899 rows) take  a very long time to run.

EXPECTED BEHAVIOR
-----------------------
Expected HCD Incremental Views to take 20 minutes each or less .

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run HCD Incremental Views for a daily load.
2. HCD Incremental Views run for a very long  time to complete.

 

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
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.