Exalytics and OBIEE 11g Report Creating Large SQL Clauses with Sub-Queries and Full Outer Joins when Run on Production Server (Doc ID 2204390.1)

Last updated on AUGUST 07, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Oracle Exalytics Software - Version 1.0.0.5.0 and later
Information in this document applies to any platform.

Symptoms

When using OBIEE 11.1.1.7.140715 on two different Exalytics servers, the same query is generating different SQL and slower performance in one environment versus the other. Specifically, the production server is creating huge SQL statements and takes 12 minutes to complete.  The same query generates a simplified SQL statement in the Development environment and takes less than two minutes to run. In both environments, the repository files and settings are the same. 

When checking the nqquery.log in the production environment, the physical SQL statement includes multiple SAWITH clauses and sub-queries and uses full outer joins.

 

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