Question Locked

Rolling out Discoverer 10G report to 1500 users

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have a requirement to roll out discoverer 10G reports to 1500+ online users (concurrent users). But I am bit sceptical about the infrastructure required for this roll out. Current infrastructure is RAC, active-active node with 2 CPUs and 4 GB memory each. Currently we have limited the concurrent usage to 150 users only.
Can I roll out discoverer reports to 1500 concurrent users?
If so, will there be any performance impacts?

Thanks
Linesh Pillai

3 replies

by robo_dev

Your question is whether there will be performance impacts when going from 150 users to 1500 concurrent users?

I would answer yes.

http://www.oracle.com/technology/products/discoverer/index.html

There is a huge 'it depends' which is how simple/complex is the report.

Their sizing calculator would indicate you need nearly 30,000 MHZ of processing power and 15GB of ram for for 1500 'simple viewer users' and over 42,000 MHZ and 30GB of RAM for 1500 Complex Viewer users.

http://www.oracle.com/technology/products/discoverer/files/discoverer904_sizing_calculator.xls

by linesh

Thanks Robo..
I am in the process of uplifting the infrastructre for meeting the requirement. Can I use the sizing calculator for AIX servers ?

Thanks
Linesh Pillai

This discussion is closed to new replies.