OBIA 11g Performance Issue In SDE_ORA_PERSISTEDSTAGE_GLLINKAGEINFORMATION_AEEXTRACT (Doc ID 2047488.1)

Last updated on OCTOBER 20, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 to 11.1.1.8.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

There is a performance issue in SDE_ORA_PERSISTEDSTAGE_GLLINKAGEINFORMATION_AEEXTRACT it takes around 70 minutes to run each day, with the number of rows varying from around 30k to 130k. It uses the same execution plan each day.

 

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