OraRep
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. It also optionally creates a separate page with charts to visualize the results and more.
| Tags | Database Utilities |
|---|---|
| Licenses | GPL |
| Operating Systems | POSIX AIX Linux Unix |
| Implementation | Unix Shell PL/SQL |
| Translations | English |
Recent releases
- 09 Jun 2008 17:57
Changes: OSPRep had been totally broken for Oracle 8i, which is hopefully fixed now. This release tries to work around issues in reports with Oracle 10g+ caused by the changed behavior in dbms_output.put_line. A small change makes this release work with 11g as well.
- 08 Oct 2007 10:59
Changes: This release has more hints, 10g fixes, and a makefile for installation.
- 09 Jul 2007 11:31
Changes: This release has working Oracle 10g support.
- 05 Jul 2007 15:05
Changes: This release has install scripts, many internal changes, and some description updates.
- 20 Mar 2007 15:25
Changes: This release adds redo buffer allocation retries to the charts, has fixes and additions in the DBWR + LGWR sections, and has basic 10g support (untested).
Heartbeat
- Popularity Score
- 272.31
- Vitality Score
- 13.30
- Subscriptions
- 61
