What Oracle version are you using?

OEM can give you what you want, if you know where to look.

A lot of people use a program called TOAD which gives a nice representation of a database. There is a trial version you can download for free