20
Autotune

The Autotune feature of Oracle Expert assists the DBA by automating routine database maintenance and tuning tasks. Autotune is designed to unobtrusively monitor the database over time and make parameter changes on behalf of the DBA. These parameter changes are a subset of the tuning capabilities of Oracle Expert.

Autotune automates the collection and analysis process for certain low risk parameter recommendations that are made within Oracle Expert. The DBA must review the list of recommendations and then choose to implement them.

Note: At this time, Autotune does not recognize Oracle Parallel Server databases. You can manually define a service for each parallel server instance you wish to tune in Oracle Parallel Server.

Once you start Autotune, Oracle Expert starts a separate process on the local client to periodically collect data from the database instance, analyze the data, and log the results of the analysis to the repository. This process continues until you stop Autotune.

Autotune was designed to have minimal impact on performance. It samples performance statistics every 15 minutes and analyzes the database environment once a day.

Autotune evaluates the following instance parameters:

• open_cursors
• db_file_multiblock_read_count
• db_file_simultaneous_writes
• log_buffer
• checkpoint_process

Autotune complements the existing Oracle Expert technology by simplifying the collection and analysis process.

Starting Autotune

To start Autotune, do one of the following:

• In the left pane of the Oracle Expert main window, click on the database you want to tune, then from the Oracle Expert menu bar select Autotune=>Start.
• In the left pane of the Oracle Expert main window, click the right mouse button over the database you want to tune and choose Start Autotune from the popup menu.

Once you start Autotune, the letter A is superimposed on the database icon to signify that Autotune has been started.

Note: Autotune continues to run until it is either explicitly stopped using the Stop command or the system is rebooted. Exiting Oracle Expert does not stop Autotune.

Stopping Autotune

To stop Autotune, do one of the following:

• In the left pane of the Oracle Expert main window, click on the database, then from the Oracle Expert menu bar select Autotune=>Stop.
• In the left pane of the Oracle Expert main window, click the right mouse button over the database and choose Stop Autotune from the popup menu.

Viewing Autotune Recommendations

The View Recommendations option will not become available until Autotune has collected enough sample data to perform an analysis and at least one analysis has been performed.

Note: After you start Autotune, it takes 24 hours before the first analysis is performed.

To view the recommendations generated by Autotune, do one of the following:

• In the left pane of the Oracle Expert main window, click on the database, then choose Autotune=>View Recommendations from the Oracle Expert menu bar.
• In the left pane of the Oracle Expert main window, click the right mouse button over the database and choose View Autotune Recommendations.

Implementing Autotune Recommendations

Once you have reviewed the tuning recommendations generated by Autotune, do one of the following:

• Use the Instance Manager to edit instance parameters identified in the View Recommendations window.
• Edit the INIT.ORA file on the target node to include the instance parameter modifications identified in the View Recommendations window.

  Note: Oracle Expert does not automatically implement Autotune recommendations.