Notes

Outline

Tuning with Oracle Expert

Objectives After completing this lesson, you should be able to do the following: Describe the features of Oracle Expert Create a tuning session Gather, view, and edit the input data Analyze the collected data, using rules Review tuning recommendations Implement tuning recommendations

Overview of Oracle Expert Tuning Methodology

Types of Tuning Routine tuning Focused tuning What-If tuning

Starting Oracle Expert Start from the console using: The Tools menu option Tuning Pack tool bar icon Related Tools from right mouse button menu

Tuning Session Scope Instance parameter tuning Application tuning Database structure sizing and placement

Collecting Input Data

Collecting Data

Collecting Schema Class Data

Collecting Data

Viewing and Editing the Collected Data

Editing Basic Rules Before Analysis

Analyzing Using Default Rules

Analyzing the Collected Data

Recommendations Overview

Recommendations Detail

Reports The Analysis report lists and explains the Oracle Expert recommendations The Session Data report displays the collected data and the generated statistics The Recommendation summary provides a recommendation overview The Workload Cross Reference report displays tables with workload requests

Recommendations Implementation

Summary In this lesson, you should have learned how to: Tune Oracle databases using the Oracle Expert system Store all tuning inputs and recommendations in the repository View and edit the tuning rules Generate the analysis report for all recommendations made by Oracle Expert