Oracle Database 11g: SQL Plan Management, Part 1 
(Jim Czuprynski) Oracle Database 11gR1 introduces SQL Plan Management, a new set of tools that allows an Oracle DBA to capture and preserve the most efficient execution plans for any SQL statement, thus limiting the impact of refreshed optimizer statistics, changes to existing applications, and even upgraded database versions. This article – the first in this series – provides a primer to SQL Plan Management principles and offers a simple demonstration of its performance tuning capabilities.
Read Article >>