10
Generating Reports

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

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

Generating a Session Data Report

You can generate a Session Data report to get detailed information about the data collected in the repository for 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 Fixedsys font type, the Regular font style, and 12 for the font size.

Contents of a Session Data Report

You can choose the data that you want Oracle Expert to include in the Session Data report. Select one or more of the following categories of data listed in the Include Sections portion of the Session Data Report dialog box:

• Database
• Instance
• Schema
• Tablespace
• Database Users
• Public Synonyms
• Environment
• Workload
• Rules

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.

Contents of an Analysis Report

The Analysis report lists each of the Oracle Expert recommendations, as well as the reason for each recommendation. This report can help you understand how and why Oracle Expert made its decisions. The Analysis report also indicates whether Oracle Expert had all the expected input for the tuning scope you specified for the tuning session.

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.

Contents of a Recommendation Summary Report

The Recommendation Summary report lists each of the Oracle Expert recommendations, as well as the reason for each recommendation. This report provides the same information as the Recommendation Detail screen.

Use this report to learn more about the general performance implications of each aspect of the database environment that Oracle Expert tunes.

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.

---