Download List

Descripción del Proyecto

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.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2011-04-06 06:37 Back to release list
0.4.4

Esta versión añade soporte para 11gR2 (no probado), nuevas secciones Top-N sentencias SQL (".. por el uso de la CPU", ".. por el tiempo transcurrido" y ".. por Invalidaciones" (10g +)), las columnas de "Última activo "y" modular "de Top SQL-N más resaltado de palabras clave en la 10g + (y esperemos que no más" al azar "espacios dentro), algunos antecedentes más útil información (ayuda contextual), y más pequeños ajustes y mejoras (incluyendo un código de formato y un cheque de (falta) se une a mejorar).
Tags: feature improvements
This release adds support for 11gR2 (untested), new Top-N SQL Statements sections ("..by CPU usage", "..by time elapsed", and "..by Invalidations" (10g+)), columns for "Last Active" and "Module" in Top-N SQL plus keyword highlighting on 10g+ (and hopefully no more "random" spaces within), some more helpful background info (context help), and more minor adjustments and improvements (including some code formatting and a check for (missing) BINDs to be improved).

Project Resources