RE: HammerDB

Hi Kellyn!
I should’ve known that you would have and awesome blogpost on this subject. Very good info! The lead dev over the Oracle system who also has some experience with SQL is the person that requested we run this. The new SQL db will be on-prem and he says that it will be magic to ensure proper hardware sizing. I don’t necessarily believe this but was looking into it nonetheless. As you stated, increase in hardware/computing power doesn’t take care of poor SQL. I’ll be passing along your blog to my director.

Thanks!

Sallie A. Cottingham, OCP
Database Administrator
Comptroller of the Treasury
Technology Solutions
425 Rep. John Lewis Way N. | Nashville, TN 37243 sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962

[A picture containing food Description automatically generated]

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> Sent: Tuesday, April 11, 2023 12:01 PM
To: mdemenko_at_gmail.com
Cc: ORACLE-L <oracle-l_at_freelists.org>; Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> Subject: Re: HammerDB

I’m not a big fan of HammerDB with Oracle… https://dbakevlar.com/2021/04/hammerdb-cli-for-oracle-on-azure/

On Tue, Apr 11, 2023 at 09:25 Maxim <mdemenko_at_gmail.com<mailto:mdemenko_at_gmail.com>> wrote: Did you notice, there is https://github.com/TPC-Council/HammerDB/releases/download/v4.7/HammerDB-4.7-RHEL8.tar.gz - an extra tarball for RHEL8 ? On my rhel (oel) 8 box it starts without any errors (it is bundled with tcl/tk 8.6 compiled against glibc 28 - which is standard for rhel8)

Regards

Maxim

On Tue, Apr 11, 2023 at 5:45 PM Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov<mailto:Sallie.Cottingham_at_cot.tn.gov>> wrote: Hi –
Anyone have experience using HammerDB for load testing an Oracle DB? We are looking to move an Oracle DB to MS SQL and want to run HammerDB on both to compare results. I’ve been using the hammerdb.com<http://hammerdb.com/> docs and GitHub discussions to get the software and install on my Linux server. The installation was fine but when I try to run it, I end up with errors talking about the version of GLIBC. (wish8.6: /lib64/libm.so.6: version `GLIBC_2.29' not found (required by ./lib/libtk8.6.so<http://libtk8.6.so/>)) I am a DBA and not a Linux admin so I’m hesitant to do anything that might affect the os (RHEL 8). The google search results warn against messing with GLIBC.

If anyone has used HammerDB for an Oracle DB on RHEL Linux, I would love to chat with you!

Thanks!

Sallie A. Cottingham, OCP
Database Administrator
Comptroller of the Treasury
Technology Solutions
425 Rep. John Lewis Way N. | Nashville, TN 37243<https://www.google.com/maps/search/425+Rep.+John+Lewis+Way+N.+%7C+Nashville,+TN+37243?entry=gmail&source=g> sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962

[A picture containing food Description automatically generated]

--

Kellyn Gorman
DBAKevlar Blog<http://dbakevlar.com/>
about.me/dbakevlar<http://about.me/dbakevlar>

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




image/png attachment: image001.png