Re: Basic Scripts for Database Administration

From: exazonk <exazonk_at_gmail.com>
Date: Sun, 28 Jun 2009 22:36:46 -0700 (PDT)
Message-ID: <998adfe4-875f-4b0d-b5f0-d44187638c1f_at_c9g2000yqm.googlegroups.com>



snip

> That said, it's still pretty useful, and has the advantage of being in
> the Oracle kool-aide with a lot of people drinking it.  One additional
> use is being able to see what SQL it creates to do something, that has
> saved me from bothering with the manuals a number of times.  It's nice
> having a list of what backups have been done, and easily drill down
> into the details.  It's nice having a performance screen, if it turns
> into a big green or blue bar, I know to look at things.  It's nice
> being able to go directly to a plan from a running sql, make a screen
> print, and tack it up on the cubicle wall.  I like the advisor screens
> (9i too, when I had it).  I would have done the space screens
> differently, and don't trust alerts much, but they are there.  In
> general, a few minutes poking around tells me everything I need to
> know, and theoretically I could use alerts for most of that (I do use
> some - "agent unreachable" alerts are useful for db down).   I think I
> even saw an agenda for a Jonathan Lewis class that mentioned showing
> some useful things in EM.
>
> jg
> --
> _at_home.com is bogus.http://www.wsbtv.com/news/19715994/detail.html- Hide quoted text -
>
> - Show quoted text -

Thanks for your input guys.

It looks like my hand full of custom scripts is probably still sufficient for me. Received on Mon Jun 29 2009 - 00:36:46 CDT

Original text of this message