Re: Setting up monitoring and trending for Oracle

If you are serious about this job then learn to do this through SQL and PL/SQL scripts first.
Get the O'reilley book by Gurry and Corrigan. Bees or something similar on the cover. Plenty in there to get you started.

All GUI tools are limited and what are you going to do if the tool breaks? What if there is problem that requires you to be at the UNIX console? What about logging in from home? You will cry like a baby running a GUI through a 56K modem.

Every Oracle database on the planet has SQLPLUS available for use (or should) Toss in e-page, sendmail and perl or python, that's all you will ever need.

Some GUI's I was forced to use overwrote your custom scripts on each upgrade. Your life can not get any better when that happens.

And nothing is faster than when you learn to use SQL to generate SQL scripts to make mass changes. Like granting select on all 4500 stinking tables and 4300 crappy views in Peoplesoft to some role.

Besides, nothing impresses people like tearing off a complicated SQL command in SQLPLUS in an xterm. Except maybe cranking around in vi at the speed of sound.
Always consider the cool factor.

Paul Rech
Super Cool Oracle DBA

mkc87 wrote:

> I was just recently promoted to the position of Oracle DBA in my company and
> I want to set up a process by which I can monitor and maintain trends for
> the Oracle database that I'm taking care of on WinNT and Unix. I would like
> to get an idea of what other DBA's use in their work environments to monitor
> the database elements like maxextents, free space, table growth and schema.
> I'm currenly using Oracle 7.3.4 and we will be upgrading to Oracle 8.1.5 in
> the next few months. I've been looking at dbTools from Soft Tree and
> believe this is the way to go. What do other DBA's use?
Received on Sun Apr 23 2000 - 00:00:00 CDT