Thanks for the help.

Another small but important thing, while managing Oracle I have a certain

checklist of things that are done regularly to check the status of database

like Segment usage, pin...

Ok, to start with are there any system views and tables from which I can obtain information about the database. Like space usage, object ownership, user information etc.

Thanks for the help.