OraRep 0.3.4 review

OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, prov

License: GPL (GNU General Public License) File size: 125K Developer: IzzySoft

0

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.

What's New in This Release:
Compacted DBWR+LGWR stats, instance efficiency stats, load profile, undo statistics, and resource limits.