[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

430.0. "Oracle system tools" by EMILE::CHARMOILLE () Mon Sep 18 1989 16:38

    hi,
    
    I'am looking for third parties products on Oracle, for monitoring,
    tuning, and DB management.
    
    regards
    Pierre
T.RTitleUserPersonal
Name
DateLines
430.1There Are NoneMAIL::DUNCANGGerry Duncan @KCOTue Sep 19 1989 00:4422
    The only thing I have seen is a 3rd party package that improves
    the dismal performance of SQL*forms and a few packages that generate
    generic SQL statements.  As far as I know, there are no 3rd party
    packages for these Oracle functional areas just as there are none
    for Rdb/VMS.  
    
    Fortunately, Rdb/VMS has a good monitor and it is rumored that dba
    tools are in the works. 
    
    Oracle, on the other hand, could use some monitoring tools for their
    V6/TPO monitor is not good.  Their DB management is difficult due
    to the way tablespaces are pre-allocated.  Finally, they need some
    tuning help cause V6/TPO has numerous options and some of the 
    parameters are not documented well in the dba manual.  (AND it's
    not all that fast to begin with !!!)
    
    Looks like your best option is to buy consulting for $1000 per day
    (US) from Oracle.  That's what my customer did.
    
    -- gerry
    
    
430.2One that is closeMAIL::DUNCANGGerry Duncan @KCOWed Sep 20 1989 21:365
    In the Sep 18 issue of Digital Review, Charles River Data Systems
    announced a performance monitor that "observes a user's Oracle load
    and lets the potential customer know how much faster their application
    would run with Relational Accelerator."  I'll bet that is as non-biased
    as American Airlines Sabre' system !!!
430.3DBA companionVANISH::BROOMFIELDFri Sep 22 1989 14:225
    There is a very good DBA tool for Oracle called DBA companion.  I don't
    know the manufacturer's name, but in the UK it is sold by SPS Ltd in
    Woking.  This will give you all the tools a DBA needs to manage a large
    database - it's a shame that Oracle/Rdb etc. don't provide things like
    this as standard.