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.

July 25, 2006

My family's trip to Niagara


We went to Niagara on 15th July, 2006. It is a beautiful place. We limited our journey to American Falls only as to we don't have Canada visa. We went on "The Maid of the Mist", which we like very much. On the next day, we went to the "Cave of the Winds", which is a special attraction available only on the US side of the Niagara. That is most enjoyable experience. I will try to post more details later.