16
Implementing the Recommendations

The topics in this chapter include:

• Implementing Tuning Recommendations
• How to Use the Implementation Files

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:

• a description of the files Oracle Expert will 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 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.