Re: Script to Document a Database

1. Who knows? But keep in mind that MOST databases have their TEST and DEV environments... so in reality that would be about 700 different applications (not counting the SAP instances). The interesting thing is that they are spread around the world, so many of the applications are duplicated and have data of a different location. The company itself has a lot more databases, 2000 is just the (estimate) number of DBs for which they outsource DBA services.
2. Very poorly indeed. Pointless downtimes, unrecoverable databases, poor backups and not a whole lot of information. Basically... it's a big mess. That is why I want to start documenting... you need to know what you have in order to decide what to change.
3. A very large global company dedicated to non-IT stuff.
4. About 60 vith various degrees of expertise, though most are juniors.
5. NMP (Not My Problem), so I really don't know... Alan.-

On Fri, Feb 26, 2010 at 1:34 AM, <japplewhite_at_austinisd.org> wrote:

> 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
> year?
>
> 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 <cicciuxdba_at_gmail.com>
> To: hostetter.jay_at_gmail.com
> Cc: oracle-l_at_freelists.org
> Date: 02/25/2010 04:28 PM
> Subject: Re: Script to Document a Database
> Sent by: oracle-l-bounce_at_freelists.org
> ------------------------------
>
>
>
> 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?
> Alan.-
>
>
> On Thu, Feb 25, 2010 at 7:24 PM, Jay Hostetter <*hostetter.jay_at_gmail.com*<hostetter.jay_at_gmail.com>>
> 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").
>
> Jay
>
> On Thu, Feb 25, 2010 at 11:52 AM, Jared Still <*jkstill_at_gmail.com*<jkstill_at_gmail.com>>
> 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: *http://jkstill.blogspot.com* <http://jkstill.blogspot.com/>
> Home Page: *http://jaredstill.com* <http://jaredstill.com/>
>
>
>
> *http://www.freelists.org/webpage/oracle-l*<http://www.freelists.org/webpage/oracle-l>
>
>
>
>
>
>

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