ODA tool has been written to analyse Oracle database object
dependencies between database objects such as procedures, tables, views etc.
The tool can also be used to analyse object dependencies
between objects in Forms source code and block properties and also the Oracle database.
Object dependencies which can be seen in view SYS.PUBLIC_DEPENDENCY,
are specified and supplemented with a context of object use
(it is possible to see some lines till the line in which the object is mentioned).
The hierarchy of dependencies is visualized as a dependency tree with support of display of a object context.
There is an opportunity of delivery HTML of reports:
- All detail Oracle objects which are used in parental object with dependencies context of use;
- The text of the program with the dependency allocated by color;
ODA will give you the answer to questions about application dependencies:
- What Oracle database objects will be mentioned with alter the table/procedure/package?
- What DML operations are carried out above the table(select/update/delete/insert)?
From this it is possible to draw a conclusion what privileges to give the user;
- While upgrading application in other environment (9i/10g/Java) can be planned that varies;
- Context of usage object display
- Object dependencies tree
- Detail object dependency search in parent object
- Database links usage
- Globals and Parameters in forms
- Application objects relationships
- Forms statistics
