This content has been marked as final. Show 3 replies
It is hard to know what the problem is without some information about what Discoverer is doing when you select a page item. You need to look at the SQL being run, either using the SQL inspector or better still, use a database monitoring tool to examine the SQL and the optimizer plan the database is using.
Also make sure that your product id is a mandatory parameter to ensure that Discoverer always using a product id condition.
I had the Discovery admin check oem and he can see that when the page item is selected that the cpu is busy processing the data for the 15-20 mins, no additional call is made to the database.
I installed Discovery Desktop today and the same report changes tabs almost instantaneously through it, so I'm left scratching my head.
I do see occasional warnings about low heap memory on the AS but on Discovery Desktop with even a 15k memory cache the report only took a few seconds to switch pages.
The admin has advised to raise an SR with Oracle but I'd be interested in any areas to check.
Edited by: dobrien_ie on Jun 1, 2012 3:40 PM