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 ...

Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.