|
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
|
