OraRep is a PL/SQL code snippet that enables users to generate a detailed report on the performance of their Oracle databases. It offers a range of customizable options and features for users to analyze and improve their database performance.
This user-friendly script fits easily into a cron task for regular scheduling of HTML report creation. Sample output is included, making it easy for users to see the type of reports they can expect to generate.
For Oracle StatsPack Reports based on Snapshot Levels up to 7, users can utilize the OSPRep plugin included in the project. OSPRep also offers users more detailed reporting on specific issues, providing higher quality reports with additional data analysis.
Additional features in this release include a page option for visualizing results through charts.
Bug fixes include the complete repair of OSPRep for Oracle 8i and working around issues in reports with Oracle 10g+ caused by the changed behavior in dbms_output.put_line. Finally, a small change ensures that this release works with 11g as well. Overall, OraRep is an essential and highly effective software tool for database administrators who want to create detailed and informative HTML reports on their Oracle database instances.
Version 0.4.3: N/A