Re: Script to Document a Database

From: Karl Arao <karlarao_at_gmail.com>
Date: Fri, 26 Feb 2010 01:13:34 +0800
Message-ID: <12ee65601002250913h6b228378m2caa16cac035c232_at_mail.gmail.com>

I agree with you Brandon, it depends on what you want to see... an even more comprehensive stuff is just to run RDA on the database.

And it's also a matter of quick deployment.. sometimes I find RDA too tedious to run because I still have to configure some stuff. So I've got just one script.. copy->paste->run get the spooled html output.. analyze then do a quick health check..

But I also make it a point I have an RDA of the database once in a while..

• Karl Arao Blog: karlarao.wordpress.com Wiki: karlarao.tiddlyspot.com

On Fri, Feb 26, 2010 at 1:00 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> I’d never seen either orasnap or the snapshot scripts from Jeff Hunter until
> now.  Both are pretty nice, but I noticed there is a lot of information in
> both of them that is already present in AWR and/or StatsPack, and everyone
> should be running one of those first, so assuming you are, then it might be
> a good idea to strip out the duplicate information in these reports.
>
>
>
> ________________________________
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 25 2010 - 11:13:34 CST