Recorded Webcast - September 28, 2011

Hey Oracle Optimizer!
Don't Mess with MY Plans

Unexpected execution plans due to system changes such as optimizer version and statistics, schema/metadata definitions, and system settings can have disastrous effects on database performance. Prior to 11g you could not guarantee a plan will change for the better and this has caused some DBAs to freeze execution plans and optimizer statistics.

SQL Plan Management (SPM) is a new 11g feature that provides controlled plan evolution by not permitting the optimizer to select a plan that is slower than the one currently executing, thus ensuring stability and consistent SQL performance.

Join Janis Griffin, Sr. Oracle DBA and performance expert, as she demonstrates how to set up SQL plan baselines and effectively use them. She will also compare SPM with previous Oracle plan stability features such as Outlines and SQL Profiles.

Recorded Webcast

Please complete the form below to view the recorded webcast