|Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack
Part Number A86647-01
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.
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.
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.
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.
To stop Autotune, do one of the following:
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.
To view the recommendations generated by Autotune, do one of the following:
Once you have reviewed the tuning recommendations generated by Autotune, do one of the following: