OBIA 11g: GENERATE_DW_DDL - Performance Issue
(Doc ID 2611235.1)
Last updated on SEPTEMBER 07, 2020
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.2 and later
Information in this document applies to any platform.
On: OBIA: 220.127.116.11.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.
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