Oracle Enterprise Manager Oracle Expert User's Guide

Implementing the Recommendations

Implementing Tuning Recommendations
How to Use the Implementation Files

The topics in this chapter include:

Implementing Tuning Recommendations

After Oracle Expert has analyzed the collected tuning data and generated recommendations you want to implement, select the Implement tab of the tuning session window, which displays the Implement page. This page allows you to generate files to help you implement the recommendations you have chosen.

The Implement page allows you to see:

a description of the files Oracle Expert can create to help you implement its current recommendations
the location where Oracle Expert will create each file

: You can select and edit the location field to have Oracle Expert create a file in a different directory.

After you select the implementation files you want Oracle Expert to create, click the Generate Files button. Oracle Expert creates the specified files.

How to Use the Implementation Files

Table 9-1 shows the type of implementation file that Oracle Expert generates to help you implement each type of tuning recommendation it makes.

Table 9-1: Implementation Files for Different Types of Recommendations
Type of Recommendations	Type of Implementation File
Instance parameter changes (instance tuning)	.ORA file
SQL changes (access method tuning and structure tuning)	.TXT file

To implement instance recommendations, replace the instance parameter values in your instance's INIT.ORA file with the instance parameter values in the .ORA file generated by Oracle Expert.

To implement recommendations made on a SQL object, for example, index, tablespace, or database user, examine the .TXT file generated by Oracle Expert. This file contains SQL statements that include the string '<TBS>' in places where you must provide the appropriate information. It also contains comments explaining steps whose commands must be supplied; for example, the steps necessary for relocating a table to a different tablespace. After you have entered the correct information, the statements in this file can be executed.

Copyright © 1996 Oracle Corporation.
All Rights Reserved.