Re: Good Windows based DBA tools for Oracle 7.3

> Jeff Farquharson wrote:

Jeff, try Oracle's Enterprise Manager. It runs under '95 or NT and works pretty well. I use it for my day-to-day dba tasks...

Adam.

> >
> > I am working on a development project where we are using Oracle 7.3 as
> > the DBMS. As the project progresses I will be playing more of a DBA
> > role. I want to evaluate good Windows based DBA tools for Oracle 7.3.
> > I require a tool that will help me with:
> > 1. day-to-day tasks - like creating tables and indexes, managing
> > users, etc
> > 2. performance monitoring - like checking locks, table extents,
> > shared memory usage, etc
> > 3. more complicated tasks - like moving or restructuring a table that
> > has production data in it and has many triggers, constraints and other
> > dependencies
> > 4. performance tuning - I understand that some tools even have
> > 'wizards' that will make recommendations for improving performance
> >

OEM is capable of doing all of the above as part of its standard installation. It certainly makes life easier for me -- no need to write long winded SQL statements for the majority of DBA work I do now :)

> > Ideally I am looking for a product that I can download from the 'net
> > and evaluate for a period before I buy.
> >

Sadly, I don't think there is a demo for it :(

> > If anyone out there can recommend such a tool I would be very grateful
> > indeed

--
=============================================================
Adam Soudure                              Hartley Poynton Ltd
Senior Systems Administrator                 Allendale Square
Phone: 09 268 3669                             St Georges Tce
Email: asoudure_at_poyntons.com.au         Perth, West Australia
=============================================================