Oracle Database 11g: New Features Overview Seminar Release 2

This one-day classroom seminar covers new features and other key enhancements in Oracle Database 11g Release 1 and Release 2, including Grid Infrastructure, Oracle Restart, storage management, high availability, improving scalability and performance, strengthening security, and data warehouse management. Instructor lecture is supported by actual and recorded product demonstrations. By attending this course, you learn how to plan your use of Oracle Database 11g Release 1 and Release 2 more effectively.

Learn to:

• Enable tracking of table data using Total Recall
• Improve disk failure recovery times by using ASM Fast Mirror Resync
• View Information About the Query result Cache
• Create AWR Baselines for future time periods
• Describe grid infrastructure and Oracle Restart

Audience

• Database Administrators
• Data Warehouse Administrator
• Project Manager
• Database Designers
• Support Engineer
• Technical Consultant

Course Topics Introduction

• Oracle Database Innovation
• Customer Testimonials
• Enterprise Grid Computing
• Oracle Database 11g: Focus Areas
• Management Automation
• Oracle Database 11g: New Features Overview Seminar
• Oracle Database 11g: Change Management Overview Seminar
• Further Information

Oracle Grid Infrastructure and Oracle Restart

• Exadata
• Oracle Grid Infrastructure
• Oracle Grid Infrastructure: Single Instance Installation
• Oracle Restart
• Controlling Oracle Restart
• ASM Cluster File System
• ASM Dynamic Volume Manager
• ASM File System Snapshot

Managing Storage

• Automatic Storage Management (ASM) Enhancements
• ASM Fast Mirror Resync: Overview
• Setting Up ASM Fast Mirror Resync
• ASM Preferred Mirror Read: Setup
• ASM Scalability and Performance Enhancements
• SecureFiles: Overview
• Hybrid Columnar Compression
• Temporary Tablspace Shrink

High Availability: Using the Data Recovery Advisor and Total Recall

• Repairing Data Failures
• Data Recovery Advisor
• Listing Data Failures
• Advising on Repair
• Setting Corruption-Detection Parameters
• Total Recall
• Creating a Flashback Data archive : Example
• Using Total Recall: Examples

High Availability: RMAN Enhancements

• RMAN Enhancements in Oracle Database 11g
• Duplicating a Database
• Active Database Duplication: Selecting the Source
• RMAN DUPLICATE Command
• Creating a Standby Database with the DUPLICATE Command
• Parallel Backup and Restore for Very Large Files
• Using RMAN Multisection Backups
• Archival Database Backup

Security and Networking New Features

• Security Enhancements
• Secure Default Configuration
• Enabling the Built-in Password Complexity Checker
• Managing Default Audits
• Privileges Audited By Default
• Adjusting Security Settings
• Setting Security Parameters
• Setting Database Administrator Authentication

Intelligent Infrastructure

• Automatic SQL Tuning in Oracle Database 11g
• Moving Window Baseline
• Baseline Templates
• Generating Baseline for a Single Time Period
• Using EM to Quickly Configure Adaptive Thresholds
• Changes to Procedures and Views
• Automated Maintenance Tasks
• Default Maintenance Resource Manager Plan

Data Warehousing Enhancements

• SQL Access Advisor in Oracle Database 11g
• Oracle Partitioning
• Partitioning Enhancements
• Interval Partitioning
• Interval Partitioning: Example
• Moving the Transition Point
• System Partitioning
• Composite Partitioning Enhancements

Additional Performance Enhancements

• Statistic Preferences: Overview
• Partitioned Tables and Incremental Statistics in Oracle Database 11g
• Hash-Based Sampling for Column Statistics
• Multicolumn Statistics: Overview
• Expression Statistics: Overview
• Deferred Statistics Publishing: Overview
• Query Result Cache
• Setting Up the Query Result Cache

Course Objectives

• Improve disk failure recovery times by using ASM Fast Mirror Resync
• Create a tablespace with encryption for added security
• Set up and modify Automatic SQL Tuning
• Gain flexibility in automatic statistics generation
• Back out data changes using Total Recall
• Describe Grid Infrastructure and Oracle Restart
• Perform cluster-wide analysis of performance