13
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 low risk parameter changes on behalf of the DBA.

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: It is a future goal of the Autotune feature to fully automate this process from collection through implementation. At this time, Autotune does not support Oracle Parallel Server databases.

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, 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 once every 15 minutes and evaluates the database environment once a day.

Stopping Autotune

To stop Autotune:

• 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

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.

  Note: Oracle Expert does not automatically implement the 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.

---