Oracle Database 11g: New Features for Administrators DBA Release 2 Training Course

Module 1: Oracle Restart

• Controlling Oracle Restart
• Using the srvctl Utility
• Manually Adding Components to the Oracle Restart Configuration

Module 2: ASM Enhancements

• Setting up ASM fast mirror resync
• Using ASM Scalability and Performance Enhancements
• ASM Disk Group Compatibility
• Using ASMCMD Extensions
• ASM File Access Control
• ASM Optimal Disk Placement

Module 3: Storage Enhancements

• Using 4 KB-Sector Disks
• Using Table Compression
• Hybrid Columnar Compression
• SQL Access Advisor
• Segment Creation on Demand

Module 4: Data Warehouse and Partitioning Enhancements

• Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
• Degree of Parallelism Enhancements
• In-Memory Parallel Query
• Partitioning Enhancements
• System-Managed Indexes for List Partitioning

Module 5: SQL Performance Analyzer

• SQL Performance Analyzer: Overview
• Using SQL Performance Analyzer
• Using Enterprise Manager to Access SQL Performance Analyzer
• SQL Performance Analyzer: Data Dictionary Views

Module 6: Database Replay

• Using Database Replay
• Database Replay System Architecture
• Supported Workloads
• Database Replay Workflow in Enterprise Manager
• Database Replay PL/SQL Procedures
• Database Replay Data Dictionary Views

Module 7: Automatic SQL Tuning

• Automatic SQL Tuning in Oracle Database 11g
• Selecting Potential SQL Statements for Tuning
• Controlling the Automatic SQL Tuning Task
• Configuring Automatic SQL Tuning
• Using the PL/SQL Interface to Generate Reports

Module 8: Intelligent Infrastructure Enhancements

• Using New Automatic Workload Repository Views
• Creating AWR Baselines
• Defining Alert Thresholds Using Static Baseline
• Controlling Automatic Maintenance Tasks
• Fixed Policy CPU Resource Management
• Scheduler Enhancements

Module 9: Diagnosability Enhancements

• Setting Up Automatic Diagnostic Repository
• ADRCI: The ADR Command-Line Tool
• Using the Enterprise Manager Support Workbench
• Running Health Checks Manually
• Using the SQL Repair Advisor

Module 10: SQL Monitoring

• SQL Monitoring in Oracle Database 11g Release 2
• Viewing Session Details
• Viewing the SQL Monitoring Report

Module 11: Performance Enhancements

• Using the DBMS_ADDM Package
• New and Modified Views
• Enabling Automatic Memory Management
• Using New Statistic Preferences Features
• Locking Enhancements
• Adaptive Cursor Sharing
• Using Table Annotation to Control Result Caching

Module 12: Application Maintenance and Upgrade Enhancements

• Online Redefinition Enhancements
• Creating and Using Invisible Indexes

Module 13: Backup and Recovery Enhancements

• Using New SET NEWNAME Clauses
• Optimized Backups
• Using New Settings for Binary Compression
• Enhancements to Database Duplication
• Creating Archival Backups
• TSPITR Enhancements and Modifications
• Creating and Using Virtual Private Catalogs

Module 14: Flashback Technology, LogMiner, and Data Pump

• Oracle Total Recall
• Flashback Transaction Backout
• Enterprise Manager LogMiner Interface
• Data Pump Legacy Mode

Module 15: Data Recovery Advisor

• Assessing Data Failures
• Data Recovery Advisor RMAN Command-Line Interface
• Data Recovery Advisor Views