My view on Oracle Business Intelligence (Applications)
On this page I will keep a yearly backup of this weblog. I have used the software of BlogBooker.
MY obiee reports are running slow in the dashboard.I have checked on items listed below and all seems to be well.Someone suggested that i should check on the presentation server but don’t know how.Please advice
2) Cache ( Cache Management)
3) Turning off logging
4) Constructing result using where clause
5) Limiting Number of Initialization block
6) Setting Query limits
7) Modeling Dimension Hierarchies Correctly
Setting NQSConfig Parameters
Could you be a bit more specific. When you are experiencing performance issues I would start with the following:
I would first try to see which queries are fired to the database. So I wouldn’t turn off logging in advance.
You could have a look at the Connection Pool settings (http://obieeblog.wordpress.com/2009/08/17/connection-pools-%E2%80%93-best-practices/)
Check a presentation of Mark Rittman;
Thank you Daan.It worked.
Pingback: Oracle BI By Bakboord – 2011 in review « Oracle BI By Bakboord
Please log in using one of these methods to post your comment:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Notify me of new posts via email.
Subscribe in a reader
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 551 other followers
Blog at WordPress.com.
Get every new post delivered to your Inbox.