Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Documenting databases
Check this out: http://www.agileinfosoftware.com/products/datapublisher/, it
might be something you are looking for.
Eric
> Don't know if this has been mentioned or if it does enough of what you're
> looking for but you can pick up something called "RDA" (remote diagnostic
> agent) from Oracle that'll give you an overview of OS setup, Network,
> performance (very high level), and RDBMS info. And the result is
web-a-fied
> which might please your manager. I forget whether I found this in metalink
or
> technet...
>
> Kip
>
>
> |The internal stuff can be documented with OraSnap.
>
> |Just google for it. It's free, detailed, and easy to setup and automate.
>
> |Jared
>
>
>
>
>
>
> |alan.aschenbrenner_at_ihs.com
> |Sent by: ml-errors_at_fatcity.com
> | 12/09/2003 03:34 PM
> | Please respond to ORACLE-L
>
>
> | To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> | cc:
> | Subject: Re: Documenting databases
>
>
>
>
>
>
> |Dan,
>
> | That's a good idea for documenting structures inside the database.
> |However, my database manager wants more high level info: database name /
> |host, oracle version, listeners, applications that use it, cron job
> |descriptions and times, main schemas and what they are used for, lists of
> |developers names that access the databse, etc...
>
> |Alan
>
>
>
>
> | Daniel Hanks
> | <hanksdc_at_about-in To: Multiple
> |recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> | c.com> cc:
> | Sent by: Subject: Re: Documenting
> |databases
> | ml-errors_at_fatcity
> | .com
>
>
> | 12/09/2003 04:09
> | PM
> | Please respond to
> | ORACLE-L
>
>
>
>
>
>
> |On Tue, 9 Dec 2003 alan.aschenbrenner_at_ihs.com wrote:
>
> |> Recently our database manager has asked us to do the
unthinkable....
> |> document our databases! To make matters worse, and without our input,
> |he
> |> went ahead and created a schema and put it in an Access database (using
> |> tables to make it look like a speadsheet). Either we use his idea or
> |come
> |> up with something else.
> |> So, I thought I'd ask everyone on the list how you do it. Text
> |files?
> |> In a database (oracle, or other)? Spreadsheets? What are the pros
and
> |> cons? Etc....
> |>
>
> |How about in each database itself.
>
> |COMMENT ON TABLE|COLUMN tab|tab.col IS '...'
>
> |comes to mind. It's simplistic, yes, but at least you don't have to
> |remember where you put your documentation...
>
> |HTH,
>
> |-- Dan
> |========================================================================
> | Daniel Hanks - Systems/Database Administrator
> | About Inc., Web Services Division
> |========================================================================
> |--
> |Please see the official ORACLE-L FAQ: http://www.orafaq.net
> |--
> |Author: Daniel Hanks
> | INET: hanksdc_at_about-inc.com
>
> |Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> |San Diego, California -- Mailing list and web hosting services
> |---------------------------------------------------------------------
> |To REMOVE yourself from this mailing list, send an E-Mail message
> |to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> |the message BODY, include a line containing: UNSUB ORACLE-L
> |(or the name of mailing list you want to be removed from). You may
> |also send the HELP command for other information (like subscribing).
>
>
>
> |--
> |Please see the official ORACLE-L FAQ: http://www.orafaq.net
> |--
> |Author:
> | INET: alan.aschenbrenner_at_ihs.com
>
> |Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> |San Diego, California -- Mailing list and web hosting services
> |---------------------------------------------------------------------
> |To REMOVE yourself from this mailing list, send an E-Mail message
> |to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> |the message BODY, include a line containing: UNSUB ORACLE-L
> |(or the name of mailing list you want to be removed from). You may
> |also send the HELP command for other information (like subscribing).
>
>
> Content-type: text/html; charset=us-ascii
>
>
> <br><font size=2 face="sans-serif">The internal stuff can be documented
with OraSnap.</font>
> <br>
> <br><font size=2 face="sans-serif">Just google for it. It's free,
detailed, and easy to setup and automate.</font>
> <br>
> <br><font size=2 face="sans-serif">Jared</font>
> <br><font size=2 face="sans-serif"><br>
> </font>
> <br>
> <br>
> <br>
> <table width=100%>
> <tr valign=top>
> <td>
> <td><font size=1
face="sans-serif"><b>alan.aschenbrenner_at_ihs.com</b></font>
> <br><font size=1 face="sans-serif">Sent by: ml-errors_at_fatcity.com</font>
> <p><font size=1 face="sans-serif"> 12/09/2003 03:34 PM</font>
> <br><font size=2 face="sans-serif"> </font><font size=1
face="sans-serif">Please respond to ORACLE-L</font>
> <br>
> <td><font size=1 face="Arial"> </font>
> <br><font size=1 face="sans-serif"> To:
Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com></font>
> <br><font size=1 face="sans-serif"> cc:
</font>
> <br><font size=1 face="sans-serif"> Subject:
Re: Documenting databases</font></table>
> <br>
> <br>
> <br><font size=2 face="Courier New"><br>
> <br>
> <br>
> <br>
> Dan,<br>
> <br>
> That's a good idea for documenting structures inside the
database.<br>
> However, my database manager wants more high level info: database
name /<br>
> host, oracle version, listeners, applications that use it, cron job<br>
> descriptions and times, main schemas and what they are used for, lists
of<br>
> developers names that access the databse, etc...<br>
> <br>
> Alan<br>
> <br>
> <br>
> <br>
>
<br>
Daniel Hanks <br>
<hanksdc_at_about-in To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <br>
c.com> cc: <br>
Sent by: <br>
ml-errors_at_fatcity <br>
.com <br>
<br>
<br>
12/09/2003 04:09 <br>
PM <br>
Please respond to <br>
ORACLE-L <br>
<br>
<br>> <br>
> <br>
> <br>
========================================================================<br>
========================================================================<br>
New">---------------------------------------------------------------------<br>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eric King INET: erickingus_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Dec 09 2003 - 19:39:25 CST