DBA CPU Benchmark3 – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports
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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
None
Oracle EBS Tables Used
Report Categories
Related Reports
DBA Database Parameter Validation, INV Item Attribute Master/Child Conflicts, DBA ORDS Configuration Validation, ECC Admin - Concurrent Programs, CAC Interface Error Summary, OPM Reconcilation, AP Invoices and Lines
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA CPU Benchmark3 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | DBA_CPU_Benchmark3.xml |
| SQL Source | DBA CPU Benchmark3.sql |
| Full Report 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
© Enginatics GmbH