BIP reports on OBIEE dashboard - very slow - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP reports on OBIEE dashboard - very slow

Received Response
625
Views
13
Comments
2»

Answers

  • Emmanuel Tchamna
    Emmanuel Tchamna Rank 2 - Community Beginner

    I applied the Patch: 25198605 - slow running dashboards, however the issue remains.

    thanks,

  • Maraprik
    Maraprik Rank 4 - Community Specialist

    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