OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

Last updated on SEPTEMBER 15, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Enterprise Manager for Fusion Middleware - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Goal

While using Oracle Business Intelligence Enterprise Edition (OBIEE), you may come across a situation where in certain dashboards take a long time to load. If your OBIEE repository is an Oracle database and is set up as a data warehouse, you can diagnose the cause of this problem using Oracle Enterprise Manager Cloud Control. You can obtain the SQL query plan for a slow dashboard, monitor the dashboard, obtain details about its performance, and so on.

This note describes how to use Enterprise Manager Cloud Control for this purpose.

Note: You can use the procedure described in this section to diagnose slow dashboards only with OBIEE 11.1.1.7.x.

 

Solution

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