327: How to Properly Utilize Outlines and SQL Profiles :Balance Between Plan Stability and Flexibility
Frank Bommarito , DBA Knowledge, Inc. Biography
Objectives: | Effective methods for tuning third-party applications. The difference between outlines and SQL Profiles and when to use which one. Methods for developing with SQL Profiles and outlines. |
Abstract: | Explore Oracle stored outlines and SQL Profiles like never before. Learn of practical usage cases. This paper will demonstrate and show specific, repeatable, examples for your environment. Learn what to do, when to do it and why it is done. Learn the difference between SQL Profiles and stored outlines. Experience the power of tools that allow for changing application performance without crazy init.ora parameters. Increase productivity, decrease exposure. |
Audiernce Focus: | DBA |
Expertise: | Intermediate |
Track: | Database |
Date: | Tuesday, April 15, 2008 |
Time: | 9:45 AM - 10:45 AM |