DBAConnect 1.5 review

DBAConnect provides convenient administration/development of Oracle database through any web browser. It's Platform independent ac

License: Other/Proprietary License File size: 2482K Developer: Datasparc Inc.

0

DBAConnect provides convenient administration/development of Oracle database through any web browser.

It's Platform independent access to Oracle database works with current security and web server infrastructure. It is very Easy to install, use and maintain.

Here are some key features of "DBAConnect":
Browse Tables, Views, Synonyms, Packages, Package Bodies, Procedures, Functions, Sequences, DBLinks, Types, Type Bodies, Libraries, Clusters, Snapshots and Queues.
Create new Table, View, Synonym, DBLink, Procedure, Function, Sequence, Package, Package Body, Type, Type Body, Constraint, Index, Trigger.
Add, remove grants.
Compile invalid objects.
Alter Table, View, Procedure, Trigger, Type, Function
View Parent Child relationship between tables.
View Dependencies between various objects.
Get the DDL for various objects.
Execute SQL, Save SQL, Open SQL script.
Run Explain Plan utility to tune SQL queries.
Export query result into .HTML, .CSV or .PDF format
Run DBMS Output utility to debug plsql programs.
View Overall SGA, Database buffer cache, Library Cache, Redo Buffer Cache, Shared Pool, Data Dictionary and UGA Space used to solve tuning problems.
View: Free space, Table space , Data file information, Rollback segment, Redo log file information
Monitor Sessions, Locks, Open Cursors, Processes. Get details for a particular session with running sql. Also kill troubled session.
Assign/Revoke grants to a particular object.
Enable/Disable Constraints, Triggers.
View/Modify Database Parameters.
Get information from V$Views

Requirements:
Operating system

Microsoft Windows 98, NT, 2000 or XP, Linux, Unix, Mac OS

Web browser

Microsoft Internet Explorer version 5.5 or above.
Netscape 6.0 or higher, Mozilla/5.0 or higher, Mozilla Firefox, Opera

Web server hardware

256MB or above RAM. Capable of operating as web server.

Application server

Works with freeware Tomcat application-server, The Resin® .

Oracle Version Compatibility

Works with version 7, 8i, 9i and 10g.