Orarep is a pl/sqlhttp://www.aliyun.com/zixun/aggregation/17348.html "> code fragment embedded in the shell script that creates a well-formed HTML report for a known database instance, provides you with a sample overview, and some hints for performance tuning. It has been tested by Oracle 8.1.7, 9.0.1, and 9.2. OSPREP provides additional plug-ins for more detailed, special-problem reports that can be randomly created to create a separate page to visualize the results.
The Orarep Osprep v0.4.7 version consists primarily of corrections, such as correcting the order of top_n elements, fixing the empty execution schedule for Top_n SQL, and some corrections in the format of exec top_n values. In addition, this version adds some new features: More contextual help, plus PGA/SGA End_snapshot AWR's statistical goals.
Software Information: http://www.izzysoft.de/ftp/net/div/izzysoft/orarep.php
Download Address: http://www.izzysoft.de/ftp/net/div/izzysoft/orarep.php