Re: Script to Document a Database

From: <>
Date: Thu, 25 Feb 2010 21:34:13 -0600
Message-ID: <>

Whoa! Surely that's a type and you meant 20 or 200, not 2000 databases!

If it's truly 2000 databases, I'd be more interested in:

1. Why so dang many?
2. How do you even manage to manage so many?
3. What's your User and/or Developer community that they require so many?
4. How many DBAs are in your group?
5. How much does your company spend on licensing and maintenance fees each 

I bet #5 is a BIG number!

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9715 (wk) / 512.935.5929 (pager)

From: Guillermo Alan Bort <>

Date:   02/25/2010 04:28 PM
Subject:        Re: Script to Document a Database
Sent by:

I know I should investigate a little before posting this, but my situation is I have about 2000 Databases in various platforms and following various different standards (when they follow a standard at all). So I would like to be able to gather all this information into a single centralized web repository (perhaps even a database). Does any of these tool provide this capability?

On Thu, Feb 25, 2010 at 7:24 PM, Jay Hostetter <> wrote:
Thank you for all of the replies.  

Jeff Hunter's script is similar to my script, except it goes into much more detail and uses HTML (which I easily added with "set markup html on").  


On Thu, Feb 25, 2010 at 11:52 AM, Jared Still <> wrote: +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: Home Page:

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

Original text of this message