Home › Discussions › Questions & Answers › Measuring Database Server CPU Speed for EBS Workloads

Measuring Database Server CPU Speed for EBS Workloads

Avatar photoCustomer April 5, 2023 at 6:04 am

We need to benchmark our new database server’s CPU speed, especially for workloads involving heavy PL/SQL processing, as many standard reports rely on this. Which Blitz Reports are available for CPU benchmarking?

Viewing 4 reply threads
  • Author
    Replies
    • Support April 7, 2023 at 7:57 am  

      You can use DBA CPU Benchmark1, DBA CPU Benchmark2, or DBA CPU Benchmark3. Benchmark1 and 2 focus mainly on PL/SQL processing time required to generate the output file from a large row count query. Benchmark3 measures performance for arithmetic calculations.

    • Avatar photoCustomer April 7, 2023 at 3:03 pm  

      To ensure the test accurately measures CPU speed and not I/O limitations, what infrastructure configuration must be guaranteed?

    • Support April 9, 2023 at 3:52 am  

      To yield meaningful results, you must ensure sufficient SGA memory is assigned so that the entire execution time is spent on CPU and not waiting on I/O. You can confirm this using the DBA SGA Active Session History report.

    • Avatar photoCustomer April 11, 2023 at 3:24 am  

      If I run Benchmark1, which uses a Cartesian product based on FND tables, approximately how many records are generated for the test?

    • Support April 12, 2023 at 11:37 am  

      The DBA CPU Benchmark1 report generates an output file of 500,000 out of a total of 561,495 records from a Cartesian product based on EBS standard FND tables.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123721

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19733

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14594

How to check if a patch is applied in Oracle EBS 12.2 14363

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14053

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11951

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9891

Migration to Java Web Start in Oracle EBS 12.2 instance 9872

Securing sensitive data with Oracle VPD 7775

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6433

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018