Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to tune Performance in OBIEE 11.1.17
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?
Answers
-
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 ;-)
0 -
Also are you comparing like with like - is your faster DB sql running at the same time from the same client?
0 -
Also, do you get the same performance issue when you run the SQL directly on the OBIEE server using SQL*Plus?
0 -
I already mentioned the query only run 12s on db no performace issue
0 -
Thanks Christiam, could you share more detail ?
0 -
no performance in DB
0 -
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?)
0 -
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).
0 -
Thanks @Gianni Ceresa. You beat me to it again!
0 -
Gianni posted one of the usual and obvious links.
0
