DBAExplorer

The DBAExplorer application was designed to be a management tool for the Oracle RDMS. The tool was developed using Borland Delphi 7.0 programming environment which provides fast Access to the Oracle database.

The code was developed after examining techniques to determine the fastest and the most effective ways of database Access to increase the overall performance of the system. As a consequence of this study, the most effective techniques and SQL statements are determined for better performance and put into action.

Here are some key features of "DBAExplorer":

￭ Object Browser: you can browse through the database objects like, Schema, Tables, Packages, Sequences, Views, Procedures, DB Links, Synonyms, Functions and advanced objects etc.

￭ DBA Utilities: Allows DBAs to perform administrative tasks in a convenient way and most of the time with just clicks. It allows you to create Tablespaces, Rollback Segments, Users and redo log files. DBAConnect also allows you to manipulate all the information regarding an instance, SGA, Block, Free space and to alter wherever it is needed.

￭ Developer Utilities: Allows you to perform the developers related actions like creating tables, views, synonyms, DB Links, Procedures, Functions, Packages and Types. It allows you to execute any SQL command through an editor window. Also provides search facility to find any object, dependencies, relationships between tables and privileges.

￭ DBA Admin: Instance Monitoring & Space Management: includes active and running jobs, SGA information (Shared pool, Library cache, UGA space used, Data Dictionary, Redo log buffer cache, Database buffer cache), Free space information, Locks, Redo log files, Object and Data files, Rollback segment, Session information, User information, Table Space and Data files. You can change or alter any information by clicking on the active link for example to drop a user or to kill a session or even to change control files.