Generic database queries

    I'am looking for some generic software that you may have written that will do numerous Oracle DBA database status queries. I know that I can go thru the tables and write my own; however I see no reason to re-invent the wheel. Basically, I'm looking for a complete generic Database describe. The sort of queries I'm interested in would give me status on:

1. Users default & temporary tablespaces.
2. Amount of space left on all tablespaces.
3. Levels of privledges granted to all users.
4. The size of the .dbs files, and to what tablespaces they are a part of.
5. Info on tables - size, indexes, alternate keys, etc.
6. Info on views - how many, identify them
7. Synonym listings - what they refer to, db associated, etc.

These are just a few; any other system specific (nice to know) queries that you could provide me would be greatly appreciated.

Thanks in advance.

   Valerie Hall Received on Tue Jul 13 1993 - 19:13:31 CEST