Rama Krishna Nalam's Blog

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.

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.
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.
Benchmark Factory - This is from Quest. The freeware version has limitations.
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
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.

August 21, 2005

Doug's Oracle Blog

OracleBlog

June 10, 2005

Favorite Oracle Tuning Sites

Following are some of my favorite sites related to Oracle Tuning

Thomas Kyte

Steve Adam's Ixora

Jonathan Lewis

Cary Milsap

Anjo Kolk

Craig Shallahamer

Connor McDonald

Mogens Norgaard

May 09, 2005

Following are some of the Oracle Blogs that I found:
Tom Kyte
Mark Rittman
Oracle Sponge

May 06, 2005

I came across one utility which can turn your gmail account into a file system in your system. It's a cool idea. It's GMAILFS. Check the following discussion about this software. It stores the files as attachment. But, you can retrieve those files without the hassle of opening, selecting a particular mail and downloading the attachment. You can do everything from Windows Explorer just like a local file system.
To avoid clutter in your gmail inbox, you may consider creating a filter for mails with prefix "GMAILFS" to archive and apply a label. I don't know how GMail management will react to this kind of software. Currently this software is working. If GMail wants, it can block this kind of software at any time.

May 02, 2005

I am using Mozilla Firefox browser since it's inception. I love that browser. The tab concept is beautiful. It's fast and interface is good. One thing that makes Firefox more useful is you can use extensions for different purposes. Once, you install firefox, go to Extensions area and download the extensions you want. I found the following extensions very helpful.
1. Adblock: This extension blocks not only the ads but any element on the web page that you don't want the browser to display to. It effectively blocks all advertisements. Once you install the extension, you can import filters, which are available online. I found the filters at the following place very good. [ http://www.geocities.com/pierceive/adblock ] Check the list of the filters before you import. You can remove those filters later, if you don't want to.

Following are the extensions I have for my Firefox: