Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Database Management tool
I quickly made a resuirement list which we will be
using to evaluate the shortlisted tools.
here is the list. ( maybe this can help other dba's
or maybe any suggestions to add something )
Requirement list
Security management
create users,roles,privs
Copy users
Delete users, roles, privs
Reorganisation
Make scripts to reorganise tablespaces, tables, indexes, automatically
when needed.
Notify when reorganisation is necessary.
Space management
See and manage the use of datafiles within a TS
See the use of tablespaces: fragmentation, users, …
Monitor the free space and notify when there will be trouble throwing
extents.
Object Management
Create, alter, drop objects
Truncate tables
Import/export utility
No Partition Management
No scheduling ( own scheduler )
Comparison
comparing schemas/init.files/objects/user roles
Difference between databases : make scripts to set them equal in data or
in structure.
Capacity planning
Follow the grow of the database and predict further growth.
Performance management
See the n heaviest processes on the database. ( + sql )
See locks
Extensive tracing
Scan databases on a regular base
Detect problems in time
Either solve the problem automatically or make a script to solve it
Benchmarking ( before and after changes to see the performance gain )
user interface
Graphical
All databases manageable from within 1 screen
List of tnsnames.ora with auto-storage of used usernames ( cfr. toad
)
extra points
No performance loss while monitoring DB
Interactive wizards
Intuitive and efficient GUI
Received on Mon Feb 19 2001 - 04:59:31 CST