Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Database Management tool

Database Management tool

From: Bjorn Naessens <bnaessens_at_roularta.be>
Date: Mon, 19 Feb 2001 02:59:31 -0800
Message-ID: <F001.002B7BE7.20010219020643@fatcity.com>

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, &#8230;   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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US