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

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:

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

Starting Autotune

To start Autotune, do one of the following:

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:

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:

Implementing Autotune Recommendations

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


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

All Rights Reserved.

Library

Product

Contents

Index