Re: Script to Document a Database
Date: Fri, 26 Feb 2010 01:13:34 +0800
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
> 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.