What is ODDIS (Version 2.11)?

The Oracle Data Dictionary Information System (ODDIS) provides a graphical user interface which allows you to retrieve most of the static information contained in the Oracle Data Dictionary (ODD). You can select a database object from the menu and the tool displays detailed information about the object in a formatted output window. From this window you then can navigate to further information connected with the chosen object. Besides this you have the possibility to edit an SQL statement in a special window. You can load, save and execute this statement. Also you can save and print the results of the execution of an SQL statement. Using the menus you can calculate statistics for user-objects and get an execution plan for the given SQL statement. An execution plan can be displyed as tree from which you can select detailed information about objects involved in the execution plan. Also you can save and print the results of the analysis of a SQL statement. As a DBA you can create new tables with information about physical devices. ODDIS provides an integrated access to the Oracle help tables and a graphical aid for navigating through the ODD.

Current Features and Progress

• for non-DBA users:
  • display of all objects owned by user, i.e. tables, columns, indexes, view, clusters, extents, sequences, links, constraints, triggers, procedures, roles, privileges, grants, ... (USER_...)
  • display of all accessible objects (ALL_...)
  • ANALYZE and EXPLAIN PLAN command for user-objects
  • output of EXPLAIN PLAN as a table or a tree graphics
• for DBAs additionally:
  • create and maintain tables with information about devices used by Oracle
  • user list (and all objects)
  • free space summary and tablespaces
  • rollback segments, data files, roles
• interactive help system for navigation
• function `find' to search for objects in the Data Dictionary
• features of wosql included
  • interactive SQL environment
  • command ring for the last 9 SQL commands
  • execution of PL/SQL blocks
  • query results can be saved
• access to the Oracle help
• ODDIS 2.11 is now much smaller than Version 2.0 and 2.1, following the rules of modular programming

• Monitoring, Analyzing and Reorganizing logical and physical storage structures (main memory and hard disks) (Dec 1996)
• Integration of a tool for the conceptual database design (includes logical and physical design as well; information is stored in the Oracle Data Dictionary and can be accessed via ODDIS) (Apr 1997)
• Full support for DDL and DML commands (Dec 1996)
• Managing (groups of) users and their privileges/roles (Dec 1996)
• Generating test data for test databases

System Requirements, Download and Installation

Documentation

The following documents are available:

Acknowledgments