ODDIS , the Oracle Data Dictionary Information System, by Michael Gertz, is a Tcl extension that shows most of the static information about the Oracle V7 Data Dictionary.
When you click on a database object, the tool displays detailed information about it in a formatted output window. One can perform ANALYZE, EXPLAIN and other SQL commands in a gui window. One can create tables with information about physical devices. One can see constraints and comments. Execution of PL/SQL blocks is now supported. Display of user lists, all objects, free space summaries, tablespaces, rollback segments, data files, roles, etc. are available.