My Oracle Support Banner

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

Last updated on SEPTEMBER 03, 2021

Applies to:

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
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.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

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
Goal
Solution
 Prerequisites
 Case Flow
 Action Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.