OraRep 0.4.7

A PL/SQL snippet
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.

last updated on:
October 17th, 2011, 15:31 GMT
price:
FREE!
developed by:
IzzySoft
homepage:
www.izzysoft.de
license type:
GPL (GNU General Public License) 
category:
ROOT \ Database \ Database APIs

FREE!

In a hurry? Add it to your Download Basket!

user rating 14

3.0/5
 

0/5

Rate it!
3 Screenshots
OraRepOraRepOraRep
What's New in version 0.4.6
  • connecting a 10g DB using a 9i client leads to dbms_output.put_line truncating its output after the 254th character (10g doesn't issue an error message any longer until you reach the limit of 32k chars). Applied a work-around to fix this.
  • + added some more hints to the table stats (adapted from OSPRep)
  • + added Makefile for (un)installation with the make utility. After verifying the WEBROOT (and prefix) setting, you may simply invoke "make install" (resp. "make uninstall") from inside the top-level directory of the unpacked tarball (where the Makefile resides).
read full changelog

Add your review!

SUBMIT