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

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


--
http://www.freelists.org/webpage/oracle-l