Jared,
I agree with your advantages. I am a big believer in the last point.
If you don't know how stuff works, you are helpless in the absence of the
tool (I'm dealing with this frustration right now...not me, but someone else
who can't live without a certain tool). I am a big believer in figuring out
how things work (a few on the list can vouch for me on that one...), but it
is not always the most economical method to manage many systems. There comes
a point where you don't need to reinvent the wheel and update it for each
new release. I don't have access to the advance releases and all platforms
of the oracle server, so I am limited in what I can do, even if I had the
time.
Any tool, whether it is GUI or TUI (like a shell script that runs in
a cron and emails), can cause disconnect. The fault lies not in the tool,
but in the user. Tools don't cause disconnects, People do...
Dan "Waiting for Perl for Oracle DBA's to hit the shelves at SoftPro" Fink
-----Original Message-----
Sent: Friday, August 02, 2002 11:00 AM
To: Multiple recipients of list ORACLE-L
On Thursday 01 August 2002 09:45, Fink, Dan wrote:
> Case in point, many databases with
> few dbas. Logging in each morning to each database and checking status and
> metrics is very inefficient. By the time all the databases are checked,
the
> day is over. This leaves no time to diagnose and repair problems.
Scheduled
> jobs (cron/AT/dbms_job) that query the database/logs and send email is
more
> effecient. At this point you have a tool. A monitoring tool, properly
> architected and configured, can assist greatly by allowing the dbas to
> focus on preventing problems and not wasting time determining that there
is
> nothing to worry about.
>
Dan,
Advantages of rolling your own:
* they do what you want, and only what you want
* if your needs change, you can modify them
* you don't have to deal with tech support to fix your tools
* you have to learn how stuff works to monitor it
Well, that last bullet point seems to be temporary with me, I
seem to forget stuff after not being close to it for awhile.
That also serves to point out what a disconnect GUI tools are.
<shameless_self_promotion>
You want some tools? Reserve your copy of "Perl for Oracle DBA's".
:)
</shameless_self_promotion>
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
