Oracle 11g New Features Part 2

Course Description

In this Oracle online training course you will explore and complete hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g RLSE 2. Oracle 11g New Features Part 2 covers SQL Result Cache, administrative enhancements, new features in flashback, diagnostics, security, RMAN and Data Guard, and Data Pump and Partitioning enhancements.

In order to take this course you need to have taken Oracle 11g New Features Part 1 and have experience with administration of Oracle Database 10g.

 

In This Course You Will Learn How To:

• Simplify database management by implementing manageability features

• Provide proactive database monitoring by utilizing database advisors

• Use improved RMAN, Data Pump, and Flashback features to increase data availability

• Master database changes by using change management features

• Use the new features of SQL and PL/SQL

Prerequisites

You need to have equivalent experience and have taken Oracle 11g New Features Part 1 or have taken the following courses:

• Oracle 10g/11g Database Administration I Part 1

• Oracle 10g/11g Database Administration I Part 2

• Oracle 10g/11g Database Administration II Part 1

• Oracle 10g/11g Database Administration II Part 2

• Oracle 11g New Features Part 1

Outline

Module 00: Oracle 11g New Features Part 2 Online Training - Course Introduction

 

Module 01: SQL Result Cache

• Configuring the Result Cache

• Using memory_report Procedure

• Viewing Information in the Data Dictionary

 

Module 02: LAB - SQL Result Cache

 

Module 03: Administration Enhancements Part 1

• Review of Manual Memory Management

• Initialization Parameters Used

• Configure at Database Creation

• Configure on an Existing Database

• Display Memory Allocation

• Review Memory Information in the Data Dictionary

 

Module 04: Administration Enhancements Part 2

• Virtual Columns

• Invisible Indexes

• Shrinking Temporary Tablespaces and Tempfiles

• Define Tablespace for Global Temporary Tables

• Comparing Objects

• Converging Data

• New Data Dictionary Views and Initialization Parameters

 

Module 05: LAB - Misc Administration

 

Module 06: Behavior Changes

• Deprecated Initialization Parameters

• New Archivelog Destination Parameters

• Deprecated Data Dictionary Views

• Automatic Maintenance Tasks

 

Module 07: Flashback New Features

• Creating a Flashback Data Archive

• Enabling and Disabling Flashback Data Archiving

• Generating Reports

• Flashback Transaction Backout

• Prerequisites for Flashback Transaction Backout

• Transaction_Backout Reports

 

Module 08: LAB - Flashback

 

Module 09: Diagnostic New Features

• Automatic Diagnostic Repository

• Investigating and Resolving Problems

• Using the Command-Line Tool ADRCI

• The Support Workbench

• Incident Packaging Service

• SQL EST Case Builder

• SQL Test Case Builder from Support Workbench

• Health Monitor Checks

• Manual Checks

 

Module 10: LAB - Diagnostics

 

Module 11: Security New Features

• The SYSASM Privilege

• Stronger Password Hash Algorithm

• Default Auditing

• Delayed Failed Login

• Case-Sensitive Password

• Password Management

• Tablespace Encryption

• Oracle Wallet

• Securefile

• Using Securefiles with Lobs

 

Module 12: LAB - Security

 

Module 13: RMAN and Data Guard New Features

• Enhanced Block Media Recovery

• Long-Term Backups

• New Options for Validate Command

• Configuring an Archived Redo Log Deletion Policy

• Active (network-based) Database Duplication

• Data Guard Improvements

• Enhancements to Data Guard Broker Based Management Framework

 

Module 14: LAB - RMAN

 

Module 15: Data Pump and Storage Enhancements

• Compression Enhancements

• Encryption

• Remapping a Table

• Ignoring Errors

• Enhancements to Partitioning

• New Partition Key Capabilities

 

Module 16: LAB - Data Pump and Storage Enhancements

 

Module 17: Oracle 11g New Features Part 2 Online Training - Course Summary