Oracle Database 11g New features for Administrators Release 2

5 Day Course
Hands On
Official Oracle Curriculum
Code OC11GNFA

This course has been retired. Please view currently available Oracle 11G Training Courses.

Modules

Hide all

Oracle Grid Infrastructure (5 topics)

  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Creating an ASM Disk Group
  • ASM Cluster File System
  • ASM Dynamic Volume Manager
  • ASM File System Snapshot

Installation and Upgrade Enhancements (4 topics)

  • Installing Oracle Database 11g Release 2
  • Oracle Database Upgrade Enhancements
  • Online Patching
  • Upgrading Your Time Zone File and Timestamp with Time Zone Data

Oracle Restart (3 topics)

  • Controlling Oracle Restart
  • Using the srvctl Utility
  • Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements (6 topics)

  • Seting up ASM fast mirror resync
  • Using ASM Scalability and Performance Enhancements
  • ASM Disk Group Compatibility
  • Using ASMCMD Extensions
  • ASM File Access Control
  • ASM Optimal Disk Placement

Storage Enhancements (5 topics)

  • Using 4 KB-Sector Disks
  • Using Table Compression
  • Hybrid Columnar Compression
  • SQL Access Advisor
  • Segment Creation on Demand

Data Warehouse and Partitioning Enhancements (5 topics)

  • Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  • Degree of Parallelism Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • System-Managed Indexes for List Partitioning

Oracle SecureFiles (5 topics)

  • Enabling SecureFiles Storage
  • Creating SecureFiles
  • Using SecureFile Compression
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles

Security and Networking Enhancements (8 topics)

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Tablespace Master Key Re-Key
  • Supporting IPv6 Address Notification

SQL Performance Analyzer (5 topics)

  • SQL Performance Analyzer: Overview
  • Using SQL Performance Analyzer
  • Using Enterprise Manager to Access SQL Performance Analyzer
  • SQL Performance Analyzer: PL/SQL Example
  • SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management (6 topics)

  • SQL Plan Management: Overview
  • Loading SQL Plan Baselines
  • Using the MIGRATE_STORED_OUTLINE Functions
  • Viewing Important Baseline SQL Plan Attributes
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy

Database Replay (6 topics)

  • Using Database Replay
  • Database Replay System Architecture
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager
  • Database Replay PL/SQL Procedures
  • Database Replay Data Dictionary Views

Automatic SQL Tuning (5 topics)

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Controlling the Automatic SQL Tuning Task
  • Configuring Automatic SQL Tuning
  • Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements (7 topics)

  • Using New Automatic Workload Repository Views
  • Creating AWR Baselines
  • Defining Alert Thresholds Using Static Baseline
  • Controlling Automatic Maintenance Tasks
  • Fixed Policy CPU Resource Management
  • Instance Caging
  • Scheduler Enhancements

Diagnosability Enhancements (7 topics)

  • Seting Up Automatic Diagnostic Repository
  • ADRCI: The ADR Command-Line Tool
  • Incident Packaging Service (IPS)
  • Using the Enterprise Manager Support Workbench
  • Invoking IPS Using ADRCI
  • Running Health Checks Manually
  • Using the SQL Repair Advisor

SQL Monitoring (3 topics)

  • SQL Monitoring in Oracle Database 11g Release 2
  • Viewing Session Details
  • Viewing the SQL Monitoring Report

Performance Enhancements (7 topics)

  • Using the DBMS_ADDM Package
  • New and Modified Views
  • Enabling Automatic Memory Management
  • Using New Statistic Preferences Features
  • Locking Enhancements
  • Adaptive Cursor Sharing
  • Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements (2 topics)

  • Online Redefinition Enhancements
  • Creating and Using Invisible Indexes

Backup and Recovery Enhancements (8 topics)

  • Using New SET NEWNAME Clauses
  • Optimized Backups
  • Using New Settings for Binary Compression
  • Enhancements to Database Duplication
  • Creating Archival Backups
  • TSPITR Enhancements and Modifications
  • Creating and Using Virtual Private Catalogs
  • Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump (4 topics)

  • Oracle Total Recall
  • Flashback Transaction Backout
  • Enterprise Manager LogMiner Interface
  • Data Pump Legacy Mode

Data Recovery Advisor (6 topics)

  • Assessing Data Failures
  • Data Recovery Advisor RMAN Command-Line Interface
  • Data Recovery Advisor Views
  • Setting Parameters to Detect Corruption
  • Use Data Pump in legacy mode
  • Use Data Recovery Advisor

Prerequisites

Required:

  • Working knowledge of Oracle Database 10g
  • Suggested:
  • Oracle Database 10g: New Features for Administrators Release 2
  • Oracle Database 10g: Administration Workshop I Release 2
  • Oracle Database 10g: Administration Workshop II Release 2

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Course PDF

Print

Sections