OSDN -- 开发和下载开源软件
简体中文翻译状态 translation status for zh

RSS
Download List

项目描述

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 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-10-17 01:25
OSPRep v0.4.7

此版本侧重于一些更正如正确排序 TOP_N 元素，修复"空执行计划表"上与 AWR 层 TOP_N SQL 使用和一些格式设置为较大的值在 TOP_N 由 exec 校正。此外，添加了一些新的东西： 更多上下文帮助再加 pga/sga 目标忠告为 end_snapshot 到 AWR 统计 （MK_PGAA/MK_SGASUM 根据创建）。
标签: minor fixes, Minor feature enhancements
This release focuses on some corrections such as correct ordering on TOP_N elements, fixing "empty execution plan tables" on TOP_N SQL with AWR-layer used, and some formatting correction for large values in TOP_N by exec. Furthermore, some new things have been added: more context help again, plus pga/sga target advice for end_snapshot to AWR stats (created depending on MK_PGAA/MK_SGASUM).

2011-09-18 10:11
0.4.6

这个版本的重点是AWR兼容层，现在还支持背景Waitevents，顶- N的SQL，和前10名等待的功能。此外，文档已经更新，和上下文帮助增加许多细节。
标签: feature improvements, minor fixes
The focus of this release is enhancements to the AWR compatibility layer, which now also supports Background-Waitevents, Top-N SQL, and Top 10 wait. Additionally, the documentation has been updated, and the context help had many details added.

2011-05-10 06:10
OSPRep v0.4.5

这个版本引入了一个兼容层运行对AWR的数据报告。这一层是不完美的，甚至也不完全（例如：最高- N的SQL语句不能被提取），但它使您能够使用与AWR数据和您自己定制的statspack脚本OSPRep。其他的变化包括顶- N的SQL和用于在10G排入统计，加上一些小的改动和修正额外的列。这是一个更新只为statspack的分支OSPRep，而不是OraRep。
标签: major feature enhancement, minor fixes
This version 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.

2011-04-06 06:37
0.4.4

此版本增加了对11gR2（未经测试），新的顶- N的SQL语句的部分（“..按CPU使用率”，“按时间过去了..”，与“失效..”（10克+）），列为“最后的主动“和”模块“在Top - N的SQL Plus的关键字高亮在10G +（希望没有更多的”随机“空间内），又有一些有用的背景信息（上下文帮助），以及更小的调整和改进（包括一些代码格式化和一对（失踪）结合检查并改进）。
标签: 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).

2008-06-10 02:57
0.4.3

OSPRep已经完全打破了Oracle 8i开始，这是希望固定。这个版本试图解决与Oracle 10g中报告的问题+在dbms_output.put_line改变行为造成的。一个小小的变化使得这个11g的发布工作，以及。
标签: StatsPack, Major bugfixes
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.

Project Resources

Project Page 下载: Bugtracker 下载: 变更日志 下载: Debian Package (deb) 下载: Demo 首页 下载: RPM 下载: TGZ