DBAExplorer 1.1 Beta

This management instrument is designed for the Oracle RDMS. The instrument 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 This management instrument is designed for the Oracle RDMS. The instrument 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. DBAExplorer permit you to access an Oracle database and execute any administrative task. Here are some of the 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: permit DBAs to execute administrative dutties in a accesible way and most of the moment with just clicks. It permit you to create Tablespaces, Rollback Segments, Users and redo log files. DBAConnect also permit you to manipulate all the knowledge regarding an instance, SGA, Block, Free space and to alter wherever it is needed. Developer Utilities: permit you to execute the developers related actions like creating tables, views, synonyms, DB Links, Procedures, Functions, Packages and Types. It permit 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 knowledge (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 knowledge by clicking on the active link for example to drop a user or to kill a session or even to change control files.