O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How Many CPUs?

The first major hardware question is: How many CPUs? This relatively simple question actually has two parts. First, what's the expected maximum number of concurrent queries? This is a much more involved question than just determining the number of reporting users who might access the data warehouse. The suggested procedure is to calculate the maximum number of concurrent users times the maximum number of concurrent reports per user that the end-user business intelligence tool permits. Plus, remember earlier we said that typical business intelligence tools often submit dozens of queries per report execution, some of whose execution may be submitted in parallel. So, the actual number of Oracle connections submitting queries could ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required