RE: Script to Document a Database
Date: Thu, 25 Feb 2010 14:45:34 +0100
Message-ID: <4814386347E41145AAE79139EAA398980DC818D552_at_ws03-exch07.iconos.be>
Jay,
Have a look at plato (http://www.dba-village.com/village/dvp_base.main) This tool can generate offline html pages to document your environment, but can also be used online using mod_plsql.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay Hostetter Sent: donderdag 25 februari 2010 14:00
To: oracle-l_at_freelists.org
Subject: Script to Document a Database
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 - 07:45:34 CST