Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11g Performance Issue
Hi,
We have a performance problem in obiee 11g. Yes, I know this is a very general definition of the problem but just try to start from one point to define it. The issue happens not all the time, but sometimes.
When I see the Session Manager, I see list of queries in running mode waiting in queue. Since, these are in queue any request coming later, is waiting many times to respond even it just executes in a few miliseconds in normal process. Where can I start to solve this problem?
Can you help me please?
Regards,
Dilek
Answers
-
I think @rmoff the legend has your answer on this one. Your logs or nework have an answer to this mystery of yours. Check the link below:
https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-summary-and-faq/
If you can also setup operational intelligence with something like Logly or Elasticsearch or sumologic, it will help you visualize upfront where your bottleneck is coming from.
Regards
Emmanuel
0 -
@EmmanuelMash pointed you in the right direction (there are also slides and videos of rmoff's Silver Bullet presentation on performance).
I would just say to not limit yourself to log files, in your case I would also not underestimate the benefits to look at DMS metrics...
0 -
This would be my starting point: https://www.rittmanmead.com/blog/2016/10/all-you-ever-wanted-to-know-about-obiee-performance-but-were-too-afraid-to-ask/
0
