Oracle Database 11g : New Features Overview Seminar

What you will learn

Oracle Database 11g Release 1 brings you many exciting new features. Topic areas covered in this one day seminar include new features in managing storage, ensuring high availability, improving scalability and performance, strengthening security, and managing datawarehouses. The instructor lecture is supported by actual and recorded product demonstrations. By attending this course, you can more effectively plan your use of Oracle Database 11g Release 1.

Learn to:
  • Configure archivelog deletion policies
  • Set up and modify Automatic SQL Tuning
  • Improve disk failure recovery times by using ASM Fast Mirror Resync
  • Create AWR Baselines for future time periods
  • Enable tracking of table data using Flashback Data Archive


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

Course Objectives
 Configure archivelog deletion policies
Create a snapshot standby database
Create a tablespace with encryption for added security
Set up and modify Automatic SQL Tuning
Perform cluster-wide analysis of performance
Gain flexibility in automatic statistics generation
Back out data changes using flashback transaction

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

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
SYSASM & ASM Disk
ASMCMD Extensions
SecureFiles: Overview

High Availability: Using the Data Recovery Advisor and Flashback
 Repairing Data Failures
Data Recovery Advisor
Listing Data Failures
Advising on Repair
Setting Corruption-Detection Parameters
Flashback Data Archive
Creating a Flashback Data Archive: Example
Using Flashback Data Archive: Examples

High Availability: RMAN and Data Guard 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: 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

Datawarehousing 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

Suggested Next Courses
 Oracle Database 11g : Change Management Overview Seminar