My Oracle Support Banner

OBIA 11g: GENERATE_DW_DDL - Performance Issue (Doc ID 2611235.1)

Last updated on SEPTEMBER 07, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On: OBIA: 11.1.1.10.2 version, DataWarehouse
       Data Source: SDE_FUSION_11_Adaptor

This issue is to do with the performance of the OOTB code for GENERATE_DW_DDL. The issue appears to be with the Build obsolete column DDLs task which references the all_tables and all_tab_columns tables.

Note: Similar issue with the GENERATE_SDS_DDL procedure and that was fixed using the Tech Note referenced in Doc ID 2538734.1 which included a 'materialize' hint when accessing the all_tables and all_tab_columns tables.


Changes

 NA

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