Report Templates

Performance Analysis for Oracle

Report Templates

Performance Analysis allows you to select from among six types of reports. From within each group, you can customize a report (by changing any of its arguments and display formats) and save it as a report template.

Report templates provide a ready mechanism for an automatic creation and distribution of usage reporting of general interest. For example, a daily report of intensive resource users can be automatically published on an intranet site for wide dissemination, awaiting your morning arrival. In this manner, customized reports can fulfill key DBA monitoring and reporting responsibilities. Use the supplied templates or create your own template-based report.

Templates are organized within the seven report groupings. From the Reports navigation tree, expand a report group node to display the supplied and user-customized templates associated with that group:

  • Report Name—A user-customized or default-supplied name for referencing and clarification. Mandatory for saving, this report will be added to and stored with the existing list under this name.

  • Description—An optional user-customized (or default-supplied) description for referencing and clarification. Useful when saving the report template.

  • Scheduled to run at—The upcoming scheduled running of the report.

  • Last Run—The most recent execution of the report.

  • Last Error—Errors generated at the time of report creation.

Those templates which have been scheduled, appear with a small clock on the icon (). For these, the Next Execution field will display the upcoming run.

For your convenience, preset supplied templates offer one-click creation of the most common DBA reporting tasks. Schedule the templates for their periodic running and distribution of reports.  

To create and save templates

  1. Click the report type of interest from the available set of six report groupings (for example: Throughput).

  2. Double-click the Add new report icon on the right pane. The Reports wizard is displayed.

  3. Follow the wizard instructions to customize the report as per your needs.

  4. In the final Summary window, enter the mandatory Report name identifying the report and optional Description for referencing and clarification. Click Save to store the template in Performance Analysis.

Viewing template executions

When focused on a specific report template, the display on the right lists the report occurrences in the upper pane, represented by its execution date and time. click an occurrence to preview: