Oracle Database 11g: SQL Performance Advisor, Part 1

(Jim Czuprynski) Oracle Database 11g Release 1 (11gR1) features the new SQL Performance Advisor that promises to ease significantly the workload of busy Oracle DBAs because it provides a way to accurately evaluate complete database workloads for “before versus after” performance changes. This article – the first in a series on new Oracle Database 11g SQL performance improvement features – reviews how to set up and utilize these features and provides a simple simulation of how SQL Performance Advisor can detect changes to an Oracle 11g database system.

Read More >>