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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle db management

RE: oracle db management

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 16 Feb 2001 04:21:31 -0800
Message-ID: <F001.002B64FE.20010216035028@fatcity.com>

From
what I hear in the tool market place, DBArtisan is good cross platform supported tool! It is fairly cheap, and provides much them same management operations as others.
<SPAN

class=248513311-16022001> 
The question arises again
the Bjorn, what is it you are trying to achieve from taking on a management tool? Do you have a checklist of operations that you want to be managed for you? Something
like:
 
Security management:
users/roles/privs
Reorganisation:
tables/indexes/tablespaces (does this have to be online 24x7) Space management:
extents/datafiles
Object Management:
create/alter/drop
Partition Management: do you use
partitions? If so what kind of operations do you need? Merge/split/drop/move/etc..
Comparison: comparing
schemas/init.files/<SPAN
class=248513311-16022001>objects/user roles/
<SPAN

class=248513311-16022001>Trends: Should it track trends in the data base
<SPAN

class=248513311-16022001>Capacity planning
<SPAN

class=248513311-16022001>Scheduled operations: anything from a tablespace reorg to running a script
Ease
of use: only achieved by evaluating all options. What
options does this tool give at object level? : truncate/drop/reorganise/alter/backup/statistics/structure/dependencies etc.
 
You
will need to go indepth, and figure through what you do on a daily basis, and how much of this you need a tool to provide for you. There is NOT a tool out there that can do EVERYTHING for you as a lot of people would like! Look at the options you have chosen to evaluate, pick what is critical/needed/and would be nice. Evaluate the tools, and pick the one that is to your personal liking, then share your findings with the list!
<SPAN

class=248513311-16022001> 
If you
have put together a list like this already, maybe you could share anything non-sensitive with the list, and we can start to point you in the right direction. I for one, am pretty much up on the functionalities of most of the major vendours tools, as I hear about them all day everyday.
<SPAN

class=248513311-16022001> 
<SPAN

class=248513311-16022001>HTH
<SPAN

class=248513311-16022001> 
<SPAN

class=248513311-16022001>Mark
<SPAN

class=248513311-16022001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Bjorn NaessensSent:   Friday, February 16, 2001 10:25To: Multiple recipients of list   ORACLE-LSubject: oracle db management
  hi fellow dba's,
   
  like i mailed before, i am in a project comparing   database management tools. I did get some nice links to some minor known tools   and i would like to address the persons who are using dbartisan of   embarcadero.
   
  Any bad or good experiences with this tool or   even rumors are very welcome. I would like to get a general idea of the public   opinion.
   
  thanks for your time
   
  Bjorn Naessens
  Junior system engineer + dba
  Roularta IT Solutions NV. Received on Fri Feb 16 2001 - 06:21:31 CST

Original text of this message

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