Check this out: http://www.agileinfosoftware.com/products/datapublisher/, it might be something you are looking for.
Eric ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 20:24 > 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 > > > > > > > |[EMAIL PROTECTED] > |Sent by: [EMAIL PROTECTED] > | 12/09/2003 03:34 PM > | Please respond to ORACLE-L > > > | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > | 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 > | <[EMAIL PROTECTED] To: Multiple > |recipients of list ORACLE-L <[EMAIL PROTECTED]> > | c.com> cc: > | Sent by: Subject: Re: Documenting > |databases > | [EMAIL PROTECTED] > | .com > > > | 12/09/2003 04:09 > | PM > | Please respond to > | ORACLE-L > > > > > > > |On Tue, 9 Dec 2003 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > |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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > |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: [EMAIL PROTECTED] (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>[EMAIL PROTECTED]</b></font> > <br><font size=1 face="sans-serif">Sent by: [EMAIL PROTECTED]</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 <[EMAIL PROTECTED]></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> > <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <br> > c.com> cc: <br> > Sent by: <br> > [EMAIL PROTECTED] <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> > On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote:<br> > <br> > > Recently our database manager has asked us to do the unthinkable....<br> > > document our databases! To make matters worse, and without our input, he<br> > > went ahead and created a schema and put it in an Access database (using<br> > > tables to make it look like a speadsheet). Either we use his idea or<br> > come<br> > > up with something else.<br> > > So, I thought I'd ask everyone on the list how you do it. Text<br> > files?<br> > > In a database (oracle, or other)? Spreadsheets? What are the pros and<br> > > cons? Etc....<br> > ><br> > <br> > How about in each database itself.<br> > <br> > COMMENT ON TABLE|COLUMN tab|tab.col IS '...'<br> > <br> > comes to mind. It's simplistic, yes, but at least you don't have to<br> > remember where you put your documentation...<br> > <br> > HTH,<br> > <br> > -- Dan<br> > ========================================================================<br> > Daniel Hanks - Systems/Database Administrator<br> > About Inc., Web Services Division<br> > ========================================================================<br> > --<br> > Please see the official ORACLE-L FAQ: http://www.orafaq.net<br> > --<br> > Author: Daniel Hanks<br> > INET: [EMAIL PROTECTED]<br> > <br> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com<br> > San Diego, California -- Mailing list and web hosting services</font> > <br><font size=2 face="Courier New">---------------------------------------------------------------------<b r> > To REMOVE yourself from this mailing list, send an E-Mail message<br> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<br> > the message BODY, include a line containing: UNSUB ORACLE-L<br> > (or the name of mailing list you want to be removed from). You may<br> > also send the HELP command for other information (like subscribing).<br> > <br> > <br> > <br> > -- <br> > Please see the official ORACLE-L FAQ: http://www.orafaq.net<br> > -- <br> > Author: <br> > INET: [EMAIL PROTECTED]<br> > <br> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com<br> > San Diego, California -- Mailing list and web hosting services<br> > ---------------------------------------------------------------------<br> > To REMOVE yourself from this mailing list, send an E-Mail message<br> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<br> > the message BODY, include a line containing: UNSUB ORACLE-L<br> > (or the name of mailing list you want to be removed from). You may<br> > also send the HELP command for other information (like subscribing).<br> > </font> > <br> > <br> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Eric King INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).