November 27, 2006

Oracle/Unix/Linux Benchmarking tools

Here are some bench marking tools for Oracle that I found. I have not tested them. Please post your experiences, if any.

  1. HammerOra - Hammerora is a load generation tool for Oracle written in Tcl/Tk. Hammerora converts Oracle trace files into oratcl which can then be replayed against the Oracle database with multiple users. The package includes a TPC-C implementation.
  2. SwingBench - Swingbench is a free load generator (and benchmarks) designed to stress test an Oracle database (9i or 10g). This is written in Java. They also have DataGenerator and TraceAnalyzer tools for download.
  3. Benchmark Factory - This is from Quest. The freeware version has limitations.
  4. Oracle ORION - This is not a benchmarking tool for Oracle Server. This tool is available on linux and windows. It is not officially supported by Oracle. I've tried to use it on Solaris unsuccessfully. ORION is the Oracle I/O Numbers Calibration Tool designed to simulate Oracle I/O workloads
    - Without having to create and run an Oracle database
    - Using the Oracle database's I/O libraries
    - Using small I/Os to simulate OLTP workloads
    - Using large I/Os to simulate data warehouses
  5. IOZone - IOzone is a filesystem benchmark tool. The benchmark generates and measures a variety of file operations. This tool is ported to many platforms.

1 comment:

TriMagna3 said...

Did you have a list at
Good Oracle Links http://members.spree.com/rnalam/html/oracle/oralinks.html ?

Is it still available?

Thanks,
trimagna3 at gmail dot com