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.
ODDIS provides a graphical user interface which is programmed using Tcl/Tk developed by John Ousterhout. 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.
or previous versions from
ftp://ftp.informatik.uni-hannover.de/software/oddis/oddis-2.0.tar.gz
The distribution includes the Program, a README file, and a Copyright notice.
Installation
Put the file oddis in a directory contained in your search path. You may have to adjust the first line of oddis to match the correct location of the orawishx interpreter at your site.
Bug Reports / Suggestions
We are interested in comments, suggestions for changes or extensions and bug reports. Please mail to oddis@informatik.uni-hannover.de
The following documents are available:
Tcl/Tk
Oratcl
and wosql
ODMS
XF
Tcl/Tk
.
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.