WHAT IS ODDIS? ODDIS (Oracle Data Dictionary Information System) is intended as an aid for administrators of Oracle databases. Since the data dictionary contains a vast amount of information, it is sometimes difficult to obtain required information about certain users or database objects. The Oracle Data Dictionary Information System (ODDIS) shows most of the static information about the Data Dictionary of Oracle Version 7. You can click on a database object and the tool displays detailed information about it in a formatted output window. Besides this you have the possibility to edit a 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 a SQL statement. You can calculate statistics for user-objects and get an execution plan for a SQL statement. Further you can get a graphic for this plan. Also you can save and print the results of the analysis of a SQL statement. As DBA you can create new tables with information about devices. ODDIS provides an integrated access to the Oracle help tables. Tom Poindexter's wosql influenced the development of ODDIS and his Oratcl made it possible at all. Some ideas concerning DBA information were taken from Tim L. Olesen's ODMS - Oracle Database Management System. ODDIS 2.11 was written by Michael Bethke (bethke@informatik.uni-hannover.de) and Axel Schlueter (schluete@informatik.uni-hannover.de) and includes minor extensions to ODDIS 2.1. ODDIS 2.1 was written by Regine Kasten (kasten@informatik.uni-hannover.de) also as an one term project in computer science using ODDIS 2.0. ODDIS 2.0 was written by Michael Bethke (bethke@informatik.uni-hannover.de) and Axel Schlueter (schluete@informatik.uni-hannover.de) also as an one term project in computer science using ODDIS 1.0. ODDIS 1.0 was written by Rainer Gruetzner (gruetzne@informatik.uni-hannover.de) as an one term project in computer science. The graphical user interface was built with Tcl/Tk. If you have any suggestions, ideas or problems, please contact us. You can obtain ODDIS from ftp://ftp.informatik.uni-hannover.de/software/oddis/oddis-2.11.tar.gz FEATURES - NEW: integrated ANALYZE command for user-objects - NEW: integrated EXPLAIN command - NEW: tree-graphic for an execution plan - NEW: for DBAs additionally: create tables with information about physical devices - EVEN NEWER: ODDIS 2.11 is now much smaller than Version 2.0 and 2.1, following the rules of modular programming - EVEN NEWER: Constraints per user and comments on tables and columns included - EVEN NEWER: Function find for objects in the Data Dictionary - features of wosql included o interactive SQL environment o command ring for the last 9 SQL commands o execution of PL/SQL blocks o query results can be saved - for non-DBA users: display of all objects owned by user - for non-DBA users: display of all accessible tables, views, indexes, triggers, procedures, and roles - for DBAs additionally : user list (and all objects), free space summary, tablespaces, rollback segments, data files, roles - access to the Oracle help - interactive help system What's new about Version 2.1.1? We only included some minor functional improvements, but Michael was able to cut off many KBytes of source code. What's new about Version 2.1? Version 2.1 offers more funtionality to analyze objects or statements with the new menu Optimize. The submenu Analyze displays all user tables (or indexes, clusters) in a new window. You can select one object and calculate new statistics with compute, estimate or delete. The submenu Explain sets the optimizer_goal and gets the execution plan for a SQL statement, which must be specified in the editor of the main window. Here you can select each object in the execution plan and get more information about it. You can get the structure of the execution plan as a graphic. Also, you can save and print the results. A new submenu Devices in the System menu allows to get information about the actual mounted filesystem. The DBA can create two new tables for the Data Dictionary with information about the partitions which are used by the Oracle datafiles. What's new about Version 2.0? Using version 1.0, you had to follow the strong hierarchy of the program to find information. In Version 2.0 now you can navigate through the relations between database objects. We suggest to take a look at the help system, soon you will find out what's really new about version 2.0. Here you can see the second new feature: the automatic change of the help system if you use internal SQL-queries. The DB-Objects menu is now called All-Objects, a new menu User-Objects shows your own objects. ODDIS 2.0 provides more information about extents, clusters, constraints, view-dependencies ... Version 2.0 is written for Tk 4.0 and, as this is NOT compatible to Tk 3.6, you first have to install Tk 4.0 (Tcl 7.4) before you run ODDIS 2.0. ACKNOWLEDGEMENTS John Ousterhout (john.ousterhout@eng.sun.com) for Tcl/Tk Tom Poindexter (tpoind@advtech.uswest.com) for Oratcl and wosql Tim L. Olesen for ODMS Sven Delmas for XF Rainer Gruetzner for ODDIS 1.0 Michael Bethke and Axel Schlueter for ODDIS 2.0 Regine Kasten for ODDIS 2.1 REQUIREMENTS ODDIS 2.1.1 was developed in the following environment: tclX7.4 ftp://ftp.aud.alcatel.com/tcl/extensions/tclX7.4.tar.gz tk-4.0 ftp://ftp.cs.berkeley.edu/ucb/tcl/tk4.0.tar.Z ftp://ftp.cs.berkeley.edu/ucb/tcl/tk4.0p1.patch oratcl-2.2 ftp://ftp.aud.alcatel.com/extensions/oratcl-2.2.tar.gz You need: Oracle SQL Server - Version 7 from Oracle Oratcl (built with tclX7.4) DOCUMENTATION Due to the regulations of the University of Hannover the documentation is written in german. But the usage of ODDIS should be straightforward, since all menus and buttons are labeled in english (or what we think is english). INSTALLATION Put the file "oddis2.11" in your "bin"-directory and all of its modules (*.tcl) in an own directory. You have to change the "module_path" at the beginning of your oddis2.11-file to locate your new directory containing the modules. You may have to adjust the first line of oddis2.11 to match the correct location of the orawishx interpreter at your site. You can also change the paths for the unix-commands at the end of the file. BUG REPORTS / SUGGESTIONS We plan to extend ODDIS in the near future. Therefore we are interested in comments, suggestions for changes or extensions and bug reports. Please mail to oddis@informatik.uni-hannover.de Legal STUFF ODDIS is a tool for administrating Oracle databases ODDIS 2.1.1 Copyright (C) 1996 Michael Bethke, Axel Schlueter & Universitaet Hannover, Institut fuer Informatik ODDIS 2.1, Copyright (C) 1996 Regine Kasten & Universitaet Hannover, Institut fuer Informatik ODDIS 2.0, Copyright (C) 1995 Michael Bethke, Axel Schlueter & Universitaet Hannover, Institut fuer Informatik ODDIS 1.0, Copyright (C) 1995 Rainer Gruetzner & Universitaet Hannover, Institut fuer Informatik This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.