برنامج بكل المواصفات للجميع

5 مايو 2004

تحياتي للجميع

برنامج بكل المواصفات للجميع

DBAConnect Features
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.

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 Dependencies between various objects.
View Parent Child relationship between tables.
Get the DDL for various objects.
Execute SQL, Save SQL, Open SQL script.
Top

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.
Create new database user, tablespace, rollback segment, role and redo log.
View: Free space, Table space , Data file information, Rollback segment, Redo log file information
Run Analyze for Tables, Indexes.
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
Top

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

http://www.datasparc.com/product.html