Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disco App Server high CPU usage, Disco Applet freezes, tuning possible?

603937Apr 25 2008 — edited Oct 13 2010

Hi again,

so I am facing again a dramatic performance issue with our Discoverer.

I have a cross-table report with ten page items, one datapoint, a percentage calculation and a total.
After querying the data from the DB, building the report (calculating total and percentages) takes 50 seconds, Disco Applet is freezed, App Server shows high CPU load (one core about 60%, other three cores about 20%). The report fetches 5600 rows, which is quite nothing.

Disco Version: 10.1.2.54.25 (CPU IV).

Are there any parameters / settings on the application server to improve the performance at this place?

Thanks in advance,

Christian

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2010

Added on Apr 25 2008

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

3 comments

1,498 views