Exalytics and OBIEE 11.1.1.7+: Slow Performance On Reports That Retrieve Over 1 Million Rows; SQL Missing "WITH" and "ORDER BY" Clauses
(Doc ID 1680591.1)
Last updated on APRIL 02, 2024
Applies to:
Oracle Exalytics Software - Version 1.0.0.3.0 and laterBusiness Intelligence Server Enterprise Edition - Version 11.1.1.7.131017 and later
Information in this document applies to any platform.
Symptoms
Using Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.1 on Exalytics and noticing that reports that retrieve large volumes of data (over 1 million rows) have slow performance. In checking the SQL in the OBIEE logs, the SQL does not include the "WITH" or "ORDER BY" clauses.
This problem is not specific to any subject area, or any single report, but is seen for all the reports, and impacts performance when running large reports that retrieve over 1 million rows.
The issue is first observed in OBIEE 11.1.1.7.x running on an Exalytics Server, but is also reproducible in stand alone OBIEE 11.1.1.7.x environment.
Changes
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 |