• Decrease font size
  • Default font size
  • Increase font size

Oracle 11g New Features Part 2

 Print E-mail

Visit GogoTraining and Buy Oracle 11g New Features Part 2 Self-paced Training Course Today!Training Description

Dashcourses has partnered with GogoTraining to bring you this Self-paced Course.

Part Two of this course gives students the opportunity to explore and complete hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g RLSE 2. The course covers SQL Result Cache, administrative enhancements, new features in flashback, diagnostics, security, RMAN and Data Guard, and Data Pump and Partitioning enhancements.

Training Objectives

As a result of this training, you will be able 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

Attendees should have experience with Oracle Database 10g and the courses Oracle 10g: DBA I and II

Part 2 Outline

Module 00: Course Introduction

Module 18: SQL Result Cache

  • Configuring the Result Cache
  • Using memory_report Procedure
  • Viewing Information in the Data Dictionary

Module 19: LAB – SQL Result Cache

Module 20: Administration Enhancements

  • Automatic Memory Management
  • New Automatic Memory Initialization Parameters
  • Monitoring Memory Allocation
  • Virtual Columns
  • Creating a Table with a Virtual Column
  • Invisible Indexes
  • Creating an Invisible Index
  • Shrinking Temporary Tablespaces and Tempfiles
  • Specifying Temporary Tablespace for Global Temporary Tables
  • Creating an Initialization Parameter File from Memory
  • Comparing Objects
  • Converging Data
  • 11g New Initialization Parameters
  • New Static Data Dictionary Views in Release 11.2

Module 21: LAB – Misc Administration

Module 22: New Flashback 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 23: LAB – Flashback

Module 24: Diagnostic New Features

  • Automatic Diagnostic Repository
  • Changes to Alert Log
  • Problems and Incidents
  • Maintaining Data in the ADR
  • Structure and Location of the ADR
  • 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 25: LAB – Diagnostics

Module 26: Security New Features

  • The System 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 27: LAB – Security

Module 28: 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 29: LAB – RMAN

Module 30: Data Pump and Partitioning Enhancements

  • Compression Enhancements
  • Encryption
  • Remapping a Table
  • Ignoring Errors
  • Enhancements to Partitioning
  • New Partition Key Capabilities

Module 31: LAB – Data Pump and Partitioning

Module 32: Course Summary

  • Review Course Objectives
  • Review Content Covered