Re: Best utility to max out CPU usage by DB workload in test environment?

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Sun, 17 Nov 2024 22:23:56 -0500
Message-ID: <CAJSrDUr0PkS8UFHHCKKsEhMRHobKHfHbETFL3ux469LcUaTkXg_at_mail.gmail.com>



Hi Mladen, Thanks for replying.
Goal: It is more academic than something specific tbh. I am trying to understand CPU metrics in various views of Oracle, additionally what wait events prop up in relation to CPU maxing out. I am testing on 19c and planning to run both on-prem and against a couple of cloud vendors' offerings.

On Sun, Nov 17, 2024 at 9:14 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On Sun, 2024-11-17 at 17:09 -0500, kunwar singh wrote:
>
> Hey Oracle experts,
> What utility and flags do you suggest to quickly load Database CPU
> utilization to 100%?
> Say I have cpu_count=16 on a 64 core machine and I want the database to
> use up all 16 cpus.
>
> For example I use stress-ng to get high CPU utilization on a linux box.
>
> I am playing with swingbench but so far no luck.. Or maybe I am using it
> the wrong way :)
>
> What is the goal of the exercise? Are you trying to benchmark the CPU?
> Something like Dhrystone MIPS, but with Oracle RDBMS? People are usually
> interested in IOPS and transactions per second. IOPS is usually measured by
> SLOB or, on the OS level, by fio. For transactions per second, you should
> configure the application you want to run for the races. What version of
> Oracle RDBMS do you have in mind? What kind of hardware? I need some more
> info before starting to look into your problem.
>
> --
>
> Mladen Gogala
> Database SME
> https://dbwhisperer.wordpress.com
>
>

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 18 2024 - 04:23:56 CET

Original text of this message