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.