Re: Recommend DBA Tools?

From: Steve Butler <sbut-is_at_seatimes.com>
Date: Tue, 31 Jan 1995 11:19:20 -0800
Message-ID: <Pine.SUN.3.91.950131111351.5819G-100000_at_seatimes>


> >We would like to acquire some cool (read: graphical) tools to assist with
> >the administration of our Oracle Server for NetWare database. We think we
> >need utilities for fast dataloads and reorganizations. We would also
> >like a graphical tool to help with db administration: monitor db use,
> >monitor jobs that are executing, schedule backups, administer security.
> >And we think we need something to help us monitor performance. Have you
> >got a recommendation for a product that's cooler than say, SQL*DBA?

As a rather new ORACLE DBA myself (1-1/2 yrs with ORACLE, 19+years other platforms), I've been searching for several categories. I've pulled the ads from several magazines and have come up with this very short list.

TABLESPACE MANAGEMENT


     TSreorg    Dimeric    1-800-464-8672     Defrag/Partition 
                22020 Clarendon St, Suite 204 Column Maint.
                Woodland Hills, CA 91367      DB Migration

     easyDBA    Dimeric    1-800-464-8672     Space Mgmt 
                22020 Clarendon St, Suite 204 security, DDL scripts
                Woodland Hills, CA 91367

     DEFRAG     ARIS       1-206-433-2081
                6840 Southcenter Blvd, Suite 125
                Seattle, WA 98188

     Desktop    Platinum Technology  1-708-620-5000
                1815 South Meyers Rd 1-800-207-7528
                Oakbrook Terrace, IL 60181

     DBGENRL    BRADMARK    1-800-ASK-BRAD     reorg


PERFORMANCE MONITORING


     DB-Vision  Aston Brooke             1-215-834-3960 Multi-instance
                610 West Germantown Pike 1-800-257-7664 System & User level
                Plymouth Meeting, PA 19462              E-mail/Pager alerts

     Patrol     Dimeric                  1-800-464-8672 e-mail/pager/voice 
                22020 Clarendon St, Suite 204
                Woodland Hills, CA 91367

     DBGENRL    BRADMARK                 1-800-ASK-BRAD Windows
                                                        Drill Down

     AdHawk     Eventus                  1-800-871-4871 Windows
                1250 Bayhill Dr, Suite 113              Expert Advice
                San Bruno, CA 94066                     Drill Down

     DBTune     Database Solutions Company 1-800-794-0354 automated tuning
                Richmond, VA

DB AUDIT TRAIL


     SQL*Trax   Turnstone Software  1-415-851-9576  Archive log analyzer
                                                    Statistical Usage
                                                    Audit Trail
                                                    Point Of Recovery Analysis

DATA MODELING


     ERwin      Logic Works         1-800-78ERWIN      ER Diagrams
                214 Carnegie Center 1-609-243-0088     Reverse Engineer
                Princetone, NJ 08540

     S Designor DSP Technologies, Inc  1-708-947-4250  ER Diagrams
                One Westbrook Center                   SQL scripts
                Suite 805                              C/S application gen
                Westchester, IL 60154                  Reverse Engineer

     System     Popkin                1-212-571-3434   ER Diagrams
     Architect  11 Park Place                          Process Modeling
                New York, NY 10007                     Reverse Engineer

     InfoModeler Asymetrix      1-800-448-6543         Object Role Modeling
                 Bellevue, WA   1-206-637-1600         SQL Scripts

                                                       Data Normalizer

PL/SQL and STORED PROCEDURES


     Power Tools The Development Group  1-201-825-9511 Documenter
                 for Advanced Technology               Relationship Browser
                 12 Barnfield Ct                       Stored View Encap.
                 Upper Saddlle River, NJ 07458         SQL Inspector &
                                                       Deadlock Predictor


Perhaps my categories are all wet, but they seemed reasonable at the time.

Anybody else have a better category list for DBAs?

--Steve

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-464-2905         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111 Packet: Not currently active |
+----------------------------------------------------+
All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue Jan 31 1995 - 20:19:20 CET

Original text of this message