Changes in This Release for Oracle Database SQL Tuning Guide

The following features are new in this release:

  • Adaptive SQL Plan Management (SPM)

    The SPM Evolve Advisor is a task infrastructure that enables you to schedule an evolve task, rerun an evolve task, and generate persistent reports. The new automatic evolve task, SYS_AUTO_SPM_EVOLVE_TASK, runs in the default maintenance window. This task ranks all unaccepted plans and runs the evolve process for them. If the task finds a new plan that performs better than existing plan, the task automatically accepts the plan. You can also run evolution tasks manually using the DBMS_SPM package.

Continue reading

Query Optimizer Concepts

This chapter describes the most important concepts relating to the query optimizer. This chapter contains the following topics:

  • Introduction to the Query Optimizer

  • About Optimizer Components

  • About Automatic Tuning Optimizer

  • About Adaptive Query Optimization

  • About Optimizer Management of SQL Plan Baselines

Continue reading

SQL Tuning or SQL Optimization

Sql Statements are used to retrieve data from the database. We can get same results by writing different sql queries.
But use of the best query is important when performance is considered. So you need to sql query tuning based on the requirement.
Here is the list of queries which we use reqularly and how these sql queries can be optimized for better performance. Continue reading