2 Replies Latest reply on May 31, 2019 10:58 AM by Christian Berg

OBIEE- Report Performance Issue

Sagar Tippe May 31, 2019 10:19 AM

Hi Team,

I'm in a quite strange situation where one of my OBIEE report is running very slow (10+ mins), whereas if I took out the same report's query and run it in SQL Developer, it runs in a few seconds. I have tried multiple ways to tackle this but that didn't help.

1. Restart of OBIEE server

2. Checked temp size for java host / presentation server

3. Enable/disable the cache

4. Pass exact parameters

5. Ran that individual report, and not an entire dashboard (to get rid of any section level conditions)

Kindly guide on whatever I tried is worth to achieve my goal or there's anything else that I need to dig in?

Thanks in advance.

Sagar Tippe

1. Re: OBIEE- Report Performance Issue

Gianni Ceresa May 31, 2019 10:31 AM (in response to Sagar Tippe)

It sounds like you tried to "fix" it before to find out where time was spent.
If it takes 10 minutes you must be able to map out exactly which step took how long, as that is what will drive your "fix" approach.

Push logs and do a time profile for that analysis.
This will help you in finding where time is spent, and for each step you will be able to take appropriate actions.

(old but still totally valid: https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-summary-and-faq/ )
Like Show 0 Likes(0)

Actions
2. Re: OBIEE- Report Performance Issue

Christian Berg May 31, 2019 10:58 AM (in response to Sagar Tippe)

Just to add to Gianni's input:

The "actions" above are the ones which normally have less impact on performance than the real culprits - database, DB design and data model. I.e. most of the time it's the queries and the databases that are the issue.

Look at Robin's blog post. Look at how to create a time profile. Look at WHERE the time gets lost.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.