9
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 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. 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 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.

---