Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack
Release 9.0.1

Part Number A86647-01

Library

Product

Contents

Index

Go to previous page Go to next page

16
Implementing the Recommendations

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 Scripts tab of the tuning session window. This page allows you to generate files to help you implement the recommendations that Oracle Expert has suggested.

The Scripts page allows you to see:

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

How to Use the Implementation Files

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

Table 16-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. You can also import the changes into your current configuration from Instance Manager.

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 for which 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.


Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index