Tools and Utilities

A flavour of the tools and utilities we have written are listed below. These can be obtained from us on request, costs (if any) depend on the your needs and circumstances.

Name	Purpose/Description
CRUD	Analyse SQL, PLSQL, Pro*C, Forms (fmt) source and produce a CRUD matrix showing the tables/columns accessed and how they are accessed, Create, Read, Update, Delete. No other Oracle tools exists that provide this information, the nearest is the DBA_DEPENDENCIES view, but that will not conider source in external files such as Pro*C, or anonomous block PLSQL. The tool is used for reverse engineering code to produce a key piece of documentation useful for impact analysis.
get_scripts	A shell script that extracts all creation scripts for the given schema in the Oracle database. Objects extracted include snapshots, snapshot logs, tables, view, PLSQL source, jobs, refesh groups, indexes, grants, users granted permissions on the schema objects. This script was developed to enable the reliable extraction of schema objects so that test and development databses could be re-aligned with production. Using Oracle exp and imp was problematic when dealing with very large tables, insisting on the extent sizes being as for the large production table.
tabdump	A golden oldie from since the days before TOAD, but still useful when used with tools to store and comprae results for unit testing. This is a shell script that lists the table contents in a vertical "colimn_name : value" pairs for an easir to read format. See the Unit Testing paper on how this can be effectively used.
fvu	A simple file viewer for UNIX, that allows novice UNIX users who just want to get on and look up a few files, the ability to navigate through directories and view/edit files using asimple curses based interface. This is intended for people who do not need to use UNIX everyday, but may from time to time dip into the UNIX world.
mySCCS	Menu based interface to SCCS, allowing easy access to SCCS functions via a simple menu system
plsql_tree	Analyse PLSQL code and produce a tree of calls. Useful for understanding the structure of an application, and a good starting point when documenting a system
OraPerfTest	Integrated suite of UNIX shell and SQL*Plus scripts providing a system to collect and gather stats for measuring performnace of Oracle code
OraAdmin	Extensible menu driven UNIX system providing menu driven fucntions for managing Oracle databses and services (HTTP, Forms Servers, etc)