Using Advisors to Optimize Database Performance

Oracle Database includes a set of advisors to help you manage and tune your database. This section contains background information about these advisors and instructions for their use. The following topics are covered:

• About Advisors

• About the SQL Advisors

• About the Automatic SQL Tuning Advisor

• Configuring the Automatic SQL Tuning Advisor

• Viewing Automatic SQL Tuning Results

• Running the SQL Tuning Advisor

• Running the SQL Access Advisor

• Optimizing Memory Usage with the Memory Advisors