Re: Looking for a GOOD oracle "documenting" script

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<400EDCC5.5DF88410_at_remove_spam.peasland.com>...
> Looking at all of your requirements, you might be better suited to using
> Oracle's Enterprise Manager. With OEM, it can check your datafiles that
> are running out of room, etc and notify you if a threshold has been
> crossed. It can even be used to produce reports in HTML format and
> served on the web.
>
> HTH,
> Brian

use OEM, and grab the queries that it uses out of v$sql, schedule them to run from the operating system and mail you the output file. :)

everything that appears in enterprise manager is just a fancy front-end to a real script under the hood.

HTML?
you mean (in sqlplus)

set markup html on

yeah, my laptop is fast enough to run OEM (2.4 GHz, 512 MB memory). but I'd still rather just read the report in my inbox. in fixed-width font, no colors.

Pd

> Guy Dallaire wrote:
> >
> > I'm using some old oracle documenting/health check script. It's Okay, but it
> > dates back to oracle 7.
> >
> > I'm looking for a script that I could run every day that would document my
> > database (layout, memory structures, data files, redos, etc...) and give me
> > some sort of health check (Datafiles that are about to bust, stuff like
> > that)
> >
> > I could of course rewrite the script, but I don't have the time and I'm sure
> > there is something better out there.
> >
> > The script should work directly in sql*plus (I don't want /need/ perl DBD)
> > and if possible output a nice HTML report.
> >
> > Any suggestions appreciated.
> >
> > Thanks
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Thu Jan 22 2004 - 00:10:45 CST