DBA CPU Benchmark3 – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
This Benchmark report measures a database server’s CPU performance for arithmetic calculations by calculating about 40 million square roots.
example performance for different CPU types: seconds rows/s CPU 7 285714 AMD Ryzen 9 5950X 16-Core Processor 13 153846 12 166667 AMD EPYC 7742 64-Core Processor 31 64516 Exadata CS X8M 42 47619 Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz 42 47619 Intel(R) Xeon(R) CPU E5-2699 v4 @ 2.20GHz 41 48780 Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz 41 48780 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz 43 46512 Intel(R) Xeon(R) CPU E5-2686 v4 @ 2.30GHz 49 40816 Intel(R) Xeon(R) Platinum 8167M CPU @ 2.00GHz 47 42553 Intel(R) Xeon(R) Platinum 8167M CPU @ 2.00GHz 115 17391 SPARC-T5, chipid 1, clock 3600 MHz
Report Parameters
Oracle EBS Tables Used
Report Categories
Related Reports
CAC Inventory Accounts Setup, INV Item Attribute Master/Child Conflicts, DBA ORDS Configuration Validation, DBA Blitz Report ORDS Configuration, ECC Admin - Concurrent Programs, CAC Cost Group Accounts Setup, OPM Reconcilation, CAC Manufacturing Variance
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA CPU Benchmark3 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | DBA_CPU_Benchmark3.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-cpu-benchmark3/ |
Executive Summary
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.
Business Challenge
- 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?”
Solution
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).
Architecture
The report queries DUAL.
Key Tables:
DUAL: Used as the row generator.
Impact
- 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.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics