The DBA CPU Benchmark3 report is a specialized CPU test that focuses on floating-point arithmetic performance. Unlike the other benchmarks that test general PL/SQL loop speed or data generation, this report forces the CPU to calculate 40 million square roots. This is particularly useful for assessing the performance of scientific or financial calculations.
- Math-Intensive Workloads: "We run complex forecasting models. Which server is best for number crunching?"
- FPU Testing: "Is the Floating Point Unit (FPU) on this new chip architecture efficient?"
- Comparative Analysis: "How does the new ARM-based processor compare to x86 for math operations?"
This report executes a query that performs millions of SQRT() calculations.
Key Features:
- Floating Point Stress: Specifically targets the FPU (Floating Point Unit) of the processor.
- Minimal I/O: Like other benchmarks, it runs from memory to isolate CPU performance.
- Reference Data: Includes benchmark results for various CPU architectures (e.g., AMD EPYC, Intel Xeon).
The report queries DUAL.
Key Tables:
DUAL: Used as the row generator.
- Workload Placement: Helps decide which server pool should host math-intensive batch jobs.
- Hardware Selection: Provides data to support purchasing decisions for high-performance computing (HPC) tasks.
- Performance Baseline: Establishes a baseline for arithmetic performance.