OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)

 

 

CERTIFICATION OBJECTIVES

4.01        Automatic SQL Tuning Advisor

4.02        SQL Plan Management

4.03        SQL Access Advisor Enhancements

            Two-Minute Drill

Q&A        Self Test

 

 

Some of the most important enhancements in Oracle Database 11g pertain to the SQL tuning process. The database can run the SQL Tuning Advisor automatically to tune high-load SQL statements. SQL Plan Management is a brand feature that automatically controls SQL plan evolution by maintaining what are called SQL plan baselines. Unlike stored outlines, ...