17
Generating Reports

This chapter describes how to generate Oracle Expert reports. The topics discussed in this chapter include:

• Generating an Analysis Report
• Generating a Recommendation Summary Report
• Generating a Session Data Report
• Generating a Cross Reference Report

By default, each report is displayed after it is generated. To change the default, remove the check mark from the View After Creation button.

Generating an Analysis Report

You can generate an Analysis report to review all of the recommendations for a tuning session, as well as the rationale for those recommendations. An Analysis report for a tuning session is available only after Oracle Expert has analyzed the collected data.

During an analysis, Oracle Expert sifts through the collected data, uses its rules to generate tuning recommendations, then stores the information for the Analysis report in the repository. The Analysis report information stays in the repository until another analysis is performed for the tuning session.

You generate an Analysis report by choosing Report=>Analysis. This displays the Analysis Report dialog box, which allows you to specify a file into which Oracle Expert will write the Analysis report.

Generating a Recommendation Summary Report

You can generate a Recommendation Summary report to review all of the recommendations for a tuning session. A Recommendation Summary report for a tuning session is available only after Oracle Expert has analyzed the collected data.

You generate a Recommendation Summary report by choosing Report=>Recommendation Summary. This displays the Recommendation Summary Report dialog box, which allows you to specify a file into which Oracle Expert will write the Recommendation Summary report.

Note: One subtle difference between the Analysis report and Recommendation Summary report is that the Analysis report includes suggestions as well as recommendation information. Suggestions include observations about the database environment for which no specific recommendation can be made.

Generating a Session Data Report

You can generate a Session Data report to get detailed information about the data collected in a tuning session. If you generate this report before beginning an analysis, you can check to make sure that all the data you planned to collect has been made available to Oracle Expert.

You generate a Session Data report by choosing Report=>Session Data. This displays the Session Data Report dialog box, which allows you to specify a file into which Oracle Expert will write the Session Data report. For readability, you should print the Session Data report in landscape format (132 columns). When viewing the report in an editor, choose the Times font type, the Regular font style, and 12 for the font size. The Session Data Report also allows you to choose which sections to include such as: database, instance, schema, tablespace, database user, public synonym, environment, and workload.

Generating a Cross Reference Report

You can generate a Workload Cross Reference report to review a table and its associated requests or a request and its associated table. The report lists the information both ways so that you can quickly locate the information you need. This can be used to help you determine if your workload for a given table is complete.

You generate a Workload Cross Reference report by choosing Report=>Workload Cross Reference. This displays the Workload Cross Reference dialog box that allows you to specify a file into which Oracle Expert will write the Workload Cross Reference Report.

For readability, you should print the Workload Cross Reference report in landscape format (132 columns). When viewing the report in an editor, choose the Times font type, the Regular font style, and 12 for the font size.