Tool for Oracle Stress and Load Testing

Community Forum › Category: Database › Tool for Oracle Stress and Load Testing

0 Vote Up Vote Down

matheusdba Staff asked 4 months ago

Could you recommend a tool for stress and load testing that is free and useful?

Question Tags: plsqlbestpractices, yatra20

1 Answers

0 Vote Up Vote Down

Best Answer

matheusdba Staff answered 4 months ago

Sure!
We have tons we can use for this end on different layers:
– For I/O Performance, we have the classic “dd” from linux.
– Yet for I/O we have the ORION (Oracle I/O Numbers) which should already be in your Oracle Installation.
– From the community we have the SLOB (Silly Little Oracle Benchmark) by Kevin Closson
– Consider also HammerDB/HammerORA (not sure if it’s payed or not)
– You have also Swingbench by Dominic Giles.
– For Network Load and Throughput test you have ORATCPTEST (Doc ID 2064368.1)
This is all not to mention the obvious and recommendable RAT (Real Application Testing). It is better than all those, in general. But it’s payed. 🙂