RE: oracle db management

[Mark Leith]

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.   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/objects/user roles/ Trends: Should it track trends in the data base Capacity planning 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!   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.   HTH   Mark   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn Naessens Sent: Friday, February 16, 2001 10:25 To: Multiple recipients of list ORACLE-L Subject: 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.