SQL Plan Management

• SQL Plan Management

  Play:

  Click here to play

  Author:

  Mary Gable - click to view profile

  Description:

  Oracle 11g's New Automatic SQL Tuning feature -SQL Plan Management consists of a new set of tools that allows an Oracle DBA to capture and preserve the most efficient execution plans for any SQL statement. The purpose is to limit the impact of environmental changes such as new optimizer statistics, different storage characteristics having been implemented, new changes to existing applications, and even upgraded database versions. In a nutshell - limit unexpected regression of SQL statement performance.