+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 Home Page: http://jaredstill.com On Thu, Feb 25, 2010 at 5:53 AM, Frits Hoogland <frits.hoogland@xxxxxxxxx>wrote: > take a look at orasnap: http://www.oracle-books.com/orasnap/ > > I've used it in the past to get an overview of databases when I had only > little time to spend. > > frits > On Feb 25, 2010, at 1:59 PM, Jay Hostetter wrote: > > > 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 > > -- > //www.freelists.org/webpage/oracle-l > > >