Re: Setting up monitoring and trending for Oracle

Can't argue with that.

Regards,

William.  

EuroNet*Internet BV, http://www.euronet.nl/ Wm. G. Urquhart, Oracle DBA
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam T:+31 20 5355263, F:+31 20 5355400, E: williamu_at_nl.euro.net M:+31 06 28206038 ICQ: 56047340 In article <3902DDF9.871A58FD_at_thebestisp.com>, rechp_at_thebestisp.com says...
> 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