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)
- 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
No comments:
Post a Comment