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

LIO (logical i/o) should do a pretty good job. Avoiding testing the i/o hardware is correct, but I think you may have missed Stefan’s “LIO load only”  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jon Crisler Sent: Monday, November 18, 2024 3:43 PM
To: contact_at_soocs.de
Cc: krishsingh.111_at_gmail.com; ORACLE-L Subject: Re: Best utility to max out CPU usage by DB workload in test environment?  

I am not sure SLOB will achieve what Kunwar seeks. Pushing heavy IO will stress the storage paths, buss adapters /HBA or network cards, but may not affect CPU as much as hoped. I was able to successfully model heavy IO combined with high cpu by using both SLOB and a cpu stress utility in tandem. Stress or Stress-ng works well, but there are lots of cpu stress tests available. Another question we had to answer was "will our network/firewalls keep up with application traffic" between app jvms and Oracle db. This was done by customizing Swingbench to put heavy emphasis on network traffic. Both of these tests were successful in predicting that we would encounter both storage I/O problems and firewall problems. Storage was fixed with array tuning, adding a few more io paths. Firewall was more difficult and we had to change the platform, then do extensive tuning.

  Calibrate_IO is another good and simple IO stress test, but it is limited to a single host in a clustered / Exa environment , whereas SLOB is better for Exa / RAC workloads.  

On Mon, Nov 18, 2024 at 6:15 AM Stefan Koehler <contact_at_soocs.de> wrote:

Hello Kunwar,
I would go with SLOB ( https://github.com/therealkevinc/SLOB_distribution/tree/2.5.3 ) and run it for LIO load only.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: www.soocs.de
Twitter: _at_OracleSK

> kunwar singh <krishsingh.111_at_gmail.com> hat am 17.11.2024 23:09 CET geschrieben:
>
> 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 :)
>
> --
>
> Cheers,
> Kunwar

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






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