How to tune Performance in OBIEE 11.1.17

2933551

I have a dashboard which run within  almost 5min but its back sql run fast in Database side by 25s.

May I know why it is slower that db?

Besides, I found 2 time in Administration.  one is 27s another is 4m55s. the second one is actual dashboard run time.

How to tune the performance?

[Deleted User]

1.) Push the log level to 7

2.) Get the detailed log

3.) Check WHERE the time gets lost

4.) Start investigating.

There is no magical GO_FASTER=TRUE setting ;-)

Robert Angel

Also are you comparing like with like - is your faster DB sql running at the same time from the same client?

Joel Acha

Also, do you get the same performance issue when you run the SQL directly on the OBIEE server using SQL*Plus?

2933551

I already mentioned the query only run 12s on db no performace issue

2933551

Thanks Christiam,   could  you  share more detail ?

2933551

no performance in DB

Gianni Ceresa

2933551 wrote:I already mentioned the query only run 12s on db no performace issue

What Joel was asking is if you run that query in the DB via SQL*Plus from the OBIEE server : it's different than just "the query run in only 12s on the DB" (there are "things" which can make a huge difference .... like .... a bad networking performance?)

Gianni Ceresa

All in all you need to do a "response time profiling" : https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-analysing-results/

Only based on that you can identify what need to be tuned.

Any other approach will be just random guessing, setting things, turning them on and off hoping it will change something (and you will maybe add other issues in your system by doing so).

Joel Acha

Thanks @Gianni Ceresa. You beat me to it again!

[Deleted User]

Gianni posted one of the usual and obvious links.