June 18, 2008

The Oracle DBA's arsenal

When you want to administer Oracle on a Windows platform and come from the Unix world, you realize how limited you are with respect to what you can do.
Well, that's a thing of the past! It's now much easier and efficient to work on Windows doing the kind of wizardry that Oracle DBA's from the Unix/Linux world perform thanks to a ton of free software available. The tools that I commonly employ are:

Operating System:
  • SysInternals Process Explorer and PS Tools
    • Most notable amongst the suite is CONTIG which allows one to defragment datafiles.
  • GNU Core Utilities
    • All the utilities ported to Window
  • Grep, Sed, Gawk (ported to Windows)
Oracle:
  • JBSQL - a light SQL*Plus replacement, very lean and very fast though development has been stopped. I personally enjoy working with it very much as SQL Developer though powerful, does not allow one to work speedily
  • Senora - An Oracle shell replacement in Perl
  • DBEdit2 - I use this one sometimes when I work on migration projects and have to connect to different types of RDBMS's
  • HammerOra - an all-time favourite for performing benchmarks and scalability tests
  • ORASRP (Oracle Session Resource Profiler) - Amazingly fast tool for making sense of the extended SQL trace files. Again, a must have
Happy Administering!

No comments: