On-line training course catalogue

Oracle Database 11g: New Features Overview Seminar

Type of course: Classroom

Course details

Fee	£440
Days	1
Course code	OR11GNFOS

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

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.

Delegates will learn how 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 outline

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