Re: Looking for a GOOD oracle "documenting" script

"Guy Dallaire" <gd-newsgroups_at_spamex.com> a écrit dans le message de 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
>

Have a look at statspack in the Performance Guide and Reference.

Regards
Michel Cadot Received on Wed Jan 21 2004 - 15:16:12 CST