Overview/Description
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Change Management Overview and SQL Plan Management
recognize the steps for managing change when upgrading or reconfiguring Oracle Database, including the setting up a snapshot standby database as a test environment.
recognize the general uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change.
identify the steps for capturing the SQL workload using SQL tuning sets.
identify the different tasks that can be performed when managing components using the SQL Performance Analyzer.
recognize the ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change.
identify the elements of SQL plan management and recognize the steps for seeding SQL plan baselines.
recognize ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios.
recognize the steps for executing all phases of SQL plan management.
seed SQL Plan Baselines for your most regressing statements.