Oracle Enterprise Manager Oracle Expert User's Guide

Generating Reports

Generating a Session Data Report
Generating an Analysis Report

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

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.

Copyright © 1996 Oracle Corporation.
All Rights Reserved.