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:
- 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 GogoTraining courses:
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