OraRep Publisher's description
OraRep is a PL/SQL snippet (embedded in a shell script)....
OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more.
It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included.
OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues.
The project also optionally creates a separate page with charts to visualize the results and more.
What's New in This Release:В· This release introduces a compatibility layer to run reports against AWR data.
В· This layer is neither perfect nor even complete (e.g. Top-N SQL statements cannot be fetched), but it enables you to use OSPRep with AWR data and your own customized StatsPack scripts.
В· Other changes include additional columns for Top-N SQL and for the Enqueue Stats on 10g, plus some more minor changes and fixes.
В· This is an update just for the StatsPack branch OSPRep, not for OraRep.
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall