Re: Looking for a GOOD oracle "documenting" script

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0401212234.1d29150d_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0401211658.149c889_at_posting.google.com>...
> > "Guy Dallaire" <gd-newsgroups_at_spamex.com> wrote in message news:<NAAPb.15256$U77.1037520_at_news20.bellglobal.com>...
> > > 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
> >
> > http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=131704.1&blackframe=0
> >
> > http://www.bb4.com/ free stuff to monitor it.
> >
> > jg
>
> Joel,
>
> > 131704.1
>
> bookmarked. thanks much.
>
> Pd

Be aware that some of those scripts continue to perpetuate myths that have been debunked. The same is true for some OEM scripts. :-O

All one can say about that is to do a sanity check about what one is actually monitoring.

jg

--
@home.com is bogus.
Sometimes it's good to get every cert you can. 
http://www.signonsandiego.com/news/uniontrib/sun/currents/news_mz1c25flight.html