Sizing Exadata - Oracle Exadata Recipes: A Problem-Solution Approach - page 102

WHEN MAX(OraCPU) BETWEEN (.65*48) AND (.65*96)
THEN 'Half Rack'
WHEN MAX(OraCPU) BETWEEN (.65*96) AND (.65*192)
THEN 'Full Rack'
ELSE 'Full Rack +'
END) exa_for_compute,
(
CASE
WHEN MAX(OraIOCPU) < 72
THEN 'Quarter Rack'
WHEN MAX(OraIOCPU) BETWEEN 72 AND 168
THEN 'Half Rack'
WHEN MAX(OraIOCPU) BETWEEN 168 AND 336
THEN 'Full Rack'
ELSE 'Full Rack +'
END) exa_for_storage
FROM
(SELECT (OraCPU + (
&&num_addtl_dbs *
&&pct_resource_load *
&&margin_err * OraCPU)) *
&&core_multiplier OraCPU,
(OraIOCPU + (
&&num_addtl_dbs *
&&pct_resource_load *
&&margin_err * OraIOCPU)) *
&&core_multiplier OraIOCPU
FROM
( { ... code from Listing 5-3 ...}
ORDER BY id ASC
)
WHERE OraCPUTot < 100
/
Enter value for num_addtl_dbs: 5
Enter value for pct_resource_load: .25
Enter value for margin_err: 1.2
Enter value for core_multiplier: .5

Max Non-IO| Max IO| Exadata Recommendation | Exadata Recommendation
CPU Req| CPU Req| Compute Grid | Storage Grid
-----------|---------|------------------------|------------------------------
12.98| 18.09| Quarter Rack | Quarter Rack

Based on our existing CPU workload and overall sizing and processor comparison numbers entered, the
workload above will fit within an Exadata X2-2 Quarter Rack.

■ Note please see recipe 1-1 for Exadata database Machine configuration details.