DBAComp is an easy-to-use graphical tool for Oracle database administration. It allows to visualise the content of the data dictionary of Oracle databases. It does this in a way that allows you to drill down from one item of information to related ones in a completely graphical way. The SQL used to retrieve all of this information can be completely customised by the user. Another feature is the capability to generate SQL scripts based on this information.
I am an Oracle DBA and I use this tool all the time in my daily work. If you find yourself constantly checking the 'DBA_*' or the 'V$*' views to know what's going on in your databases, then DBAComp is just the right tool for you. It is complementary to the Enterprise Manager. I use the 2 tools together; DBAComp to check out the database or to generate scripts and EM to apply changes.
The idea to write this tool came when I started as a DBA and got
tired of rewriting all the time the same SQL statements to check out
the databases. At that time no suitable tool existed to simplify
day-to-day administration. Initially, I had written DBAComp using a
4GL environment under Windows. I had been using the Windows version
of DBAComp for a couple of years.
But then the 4GL was being phased out. As I need DBAComp for my every day work, I thought about a solution that would no longer be dependent on a 3rd party tool that is bound to disappear. I also looked for a multi-platform solution and greater flexibility. That is when I decided to write it using C++ and the graphical library Qt from TrollTech (now Nokia).
For information on the different versions and future plans have a look at the roadmap.
DBAComp is developed under the GNU General Public License (GPL). For you, that means you can use and copy it for free, give it to everyone you like (provided you respect the GPL) and modify it the way you see fit (again respecting the GPL). For details check the 'LICENSE' file coming with the distribution.
It runs on every platform Qt (2.1.0 or higher) and Oracle (8.0.5 or higher) support (in one word, many). For the detailed requirements, check out the installation instructions in the distribution. I have successfully compiled and tested it on Linux 2.2, Solaris8 Intel and Sparc, Siemens Reliant Unix 5.45, Windows and HP-UX 11.0.
Want to know more? Here are some screen shots.
So if you're interested, give it a try
and tell me what you think.