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