by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples :

(assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g)

– LIST OF USERS

SELECT OWNER,COUNT(DISTINCT TABLE_NAME) FROM ALL_TAB_COLUMNS [...]