Discussion:
sysbench on Oracle
kyle Hailey
2018-10-13 14:24:14 UTC
Permalink
Has anyone run "sysbench" against Oracle? I see a few scattered mentions on
the internet that this is possible but I don't see any examples out there.
Wanting to run the same benchmark agains MySQL , Postrgres and Oracle ( and
SQL Server as well but I that might be asking for too much !) Actually I'm
using my own benchmark in jmeter but finding it quite tedious trying to do
the same workload with different syntax and engine variations like
autocommit and different locking situations.

Kyle Hailey
Mladen Gogala
2018-10-13 20:32:27 UTC
Permalink
Hi Kyle,

I haven't run Sysbench against oracle, I have run Swingbench. As for the
multi-platform testing tool, my favourite one is HammerDB, previously
known as HammerOra:  https://www.hammerdb.com

It can run on all databases you mentioned plus DB2.

Regards
Post by kyle Hailey
Has anyone run "sysbench" against Oracle? I see a few scattered
mentions on the internet that this is possible but I don't see any
examples out there.
Wanting to run the same benchmark agains MySQL , Postrgres and Oracle
( and SQL Server as well but I that might be asking for too much !)
Actually I'm using my own benchmark in jmeter but finding it quite
tedious trying to do the same workload with different syntax and
engine variations like autocommit and different locking situations.
Kyle Hailey
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l
Robert Freeman
2018-10-15 20:17:22 UTC
Permalink
I love the ability of HammerDB to extract SQL out of 10046 trace files for replay...
It's not perfect but it's pretty good...

Robert G. Freeman
Deliverer of Enterprise Data®
Businessolver
Cell: 801-703-3405

“Greater than the death of flesh is the death of hope. The death of dreams. Against this peril we can never surrender. The future is all around us, waiting in moments of transition, to be born in moments of revelation. No one knows the shape of that future, or where it will take us. We know only that it is always born in pain.”


-----Original Message-----
From: oracle-l-***@freelists.org [mailto:oracle-l-***@freelists.org] On Behalf Of Mladen Gogala
Sent: Saturday, October 13, 2018 3:32 PM
To: oracle-***@freelists.org
Subject: Re: sysbench on Oracle

Hi Kyle,

I haven't run Sysbench against oracle, I have run Swingbench. As for the multi-platform testing tool, my favourite one is HammerDB, previously known as HammerOra:  https://www.hammerdb.com

It can run on all databases you mentioned plus DB2.

Regards
Post by kyle Hailey
Has anyone run "sysbench" against Oracle? I see a few scattered
mentions on the internet that this is possible but I don't see any
examples out there.
Wanting to run the same benchmark agains MySQL , Postrgres and Oracle
( and SQL Server as well but I that might be asking for too much !)
Actually I'm using my own benchmark in jmeter but finding it quite
tedious trying to do the same workload with different syntax and
engine variations like autocommit and different locking situations.
Kyle Hailey
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Loading...