Re: Script to Document a Database
Date: Thu, 25 Feb 2010 08:52:17 -0800
Message-ID: <bf46381002250852k722a03bcy46461d5e5852f700_at_mail.gmail.com>
+1 for OraSnap.
I've been running it once per week for quite some time.
Pro: comprehensive information about your databases
Con: some rather intensive queries - run it at the slowest periods for the database.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Thu, Feb 25, 2010 at 5:53 AM, Frits Hoogland <frits.hoogland_at_gmail.com>wrote:
> take a look at orasnap: http://www.oracle-books.com/orasnap/
>
> I've used it in the past to get an overview of databases when I had only
> little time to spend.
>
> frits
> On Feb 25, 2010, at 1:59 PM, Jay Hostetter wrote:
>
> > I have a script that we run weekly on our databases. It creates some
> basic documentation about the database (users, tablespaces, segments,
> v$parameters, jobs etc.). I was going to update this script to inlcude more
> information, but I thought I would first check to see if there are any good
> scripts out there that do this sort of thing. I didn't find too much when I
> was searching around. IIRC RDA creates a nice HTML document (it's been
> quite some time since I ran it). I was interested in pulling the
> information remotely - not using RDA locally on each box, so I have ruled
> out RDA. I don't want to be too intruisive on these database servers. I
> just wanted some handy-dandy documentation for reference without reinventing
> the wheel.
> >
> > Thank you,
> > Jay
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 25 2010 - 10:52:17 CST