This section includes "interval monitoring" based utilities and the AppsDBA interval resource profiler. These utilities have been used on many systems with excellent results and are fully compatible with the latest Oracle database and Oracle Applications releases. The utilities are non-intrusive, and do not require any modifications to existing database schemas. While many of the components are UNIX based for OS information and administration, they will function in an NT environment with some modification. Where appropriate, we have included tips on how to do this.
WORKMON is a workload characterization tool for Oracle databases.
SQLMON is a database utility that is meant to provide short term interval monitoring of SQL statements to allow the DBA to identify poorly performing SQL.
The AppsDBA resource profiler is a perl based extended SQL trace interval resource profiler. The resource profiler will parse an Oracle event 10046 level 8 or higher trace file and create an interval resource profile for each session found in the trace file.