What works better on MAC?

Here are the applications that I found useful and works great for me on MAC.

Instant Messanging Client:  Adium  - http://www.adiumx.com/

Office: OpenOffice -  http://www.openoffice.org/

Image Manipulation Tool: GIMP - http://www.gimp.org/

SFTP Client: Fugu - http://rsug.itd.umich.edu/software/fugu/

SSH: iSSH - http://www.macserve.org.uk/projects/issh/ ( I use this for SSH tunnel)

Remote Desktop: Remote Desktop Mac - http://www.microsoft.com/mac/products/remote-desktop/default.mspx

Hope this apps list help you as well.

-VK

How to Install Oracle Database Client in MAC

Well, it is intersting getting familer with new tools that you have for Mac. The very first tool, I need to perform my job is the Oracle DB Client. The latest, version I could find for Mac is 10.1.0.3.

It is very easy to install Oracle client on Mac. Just download software from Oracle website http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/macsoft.html and unpack it in the directory where you want to have your ORACLE_HOME.

Oracle Database 10g Client Release 1 (10.1.0.3) for Apple Mac OS X

    ship_mac_client.cpio.gz (344,013,902 bytes) (cksum - 3052329470)

Now, set the env in the .bash_profile and you are good to go.

ORACLE_HOME=/Users/vkaushik/Library/Oracle/10103/client/ohome; export ORACLE_HOME
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib; export DYLD_LIBRARY_PATH
JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Home; export JAVA_HOME
PATH=$PATH:$ORACLE_HOME/bin; export PATH

Run the sqlplus.

-VK

My New Mac

Last month, I got my first MacBook Pro. I heard a lot about Mac but never had one. Man, I really like it.  I use keyboard shortcuts a lot and first few days my life was measurable as I could’t use all those techniques on my Apple keyboard.

Here is a link that give you a good mapping of PC vs Apple keyboard.

http://support.apple.com/kb/HT1167

I will be posting more on my Mac as I learn.

Thanks,
VK

Free - Oracle Database Performance Analyzer

I always think that there could be an easier method to parse AWR and Statspack report. Well, AWR report is in HTML format and easier to read then the txt output. In order to get the ifnromation that I am more interested in, I have written a parsor progran to parse the txt output from Statspack and AWR. I am sure this is not the perfact output a start to summarize the result.

If you may find bug in the tool as I have testing it against only few sample output of Statspack and AWR. Please let me know how I can improve this tool.

The URL for the tool is http://www.dbapool.com/analyzer/

-VK