Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP reports on OBIEE dashboard - very slow
Answers
-
I applied the Patch: 25198605 - slow running dashboards, however the issue remains.
thanks,
0 -
Although there is slowness in loading the templates, its not seven minutes, its takes about 15- 20 seconds for the template to come up. There is a separate admin team which takes care of this and I believe this patch is applied.
Two things,
1. We noticed that when a report returning more than 20k rows is run by multiple users, the Admin server heap memory gets hogged and it does not get released even after the report is executed.
2. We are not seeing a performance issue with the reports as such but the memory is held onto and at some point we get a out of memory error(more than 30 users logged in)
3. another thing is - we used the compatability setting of 11.5 for a couple of reports which had issues with excel import. this also caused a major issue with performance, we have removed it since and raised an SR.
Does anybody know why this memory hog happens and it never gets released, even if the report gets executed.
Regards
K
0