AnsweredAssumed Answered

Datamart Extraction running slow in Oracle 12c (Clarity 14.3)

Question asked by DJ.V on Oct 26, 2017
Latest reply on Nov 13, 2017 by Suman Pramanik

Datamart Extraction is running very slow into our Clarity 14.3 with Oracle 12c.

 

Identified culprit is NBI_POPULATE_OBS_DIM_SP and most probably NBI_POPULATE_OBS_RECURSIVE_SP() which is called eventually.

 

With regards to configuration is as per CA guidelines except Oracle 12c compatibility is set to 12.2 and not 11g.

 

Open a case with CA but no luck. DBA couldn't help either.

 

Has anyone faced this issue? Thanks in advance for help.

Outcomes