Script to Document a Database
From: Jay Hostetter <hostetter.jay_at_gmail.com>
Date: Thu, 25 Feb 2010 07:59:50 -0500
Message-ID: <3774d30f1002250459m6448c707k6aeac3a2e3d2a296_at_mail.gmail.com>
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.
Date: Thu, 25 Feb 2010 07:59:50 -0500
Message-ID: <3774d30f1002250459m6448c707k6aeac3a2e3d2a296_at_mail.gmail.com>
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-lReceived on Thu Feb 25 2010 - 06:59:50 CST