Course Icon Oracle Database Training

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Cours

0800 1337 401

Overview

This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g Release 1 and Release 2. The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g Release 2. Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 2 and how these can be implemented in their current Oracle installations.

Prerequisites

Delegates who wish to attend this Oracle Database 11g Release 2 for Experienced 10g Database Administrators course should have good understanding of Oracle Database 10g administration.

Objectives

This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the skills needed install, upgrade, implement and support Oracle Database 11g Release 1 and Release 2.

Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 1 and Release 2 and how these can be implemented in their current Oracle installations.

Outline

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: NEW MANAGEMENT FEATURES

  • Log File Changes
  • Parameter File Management Changes
  • Automatic Diagnostic Repository
  • ADRCI Command Line Tool
  • Automatic Memory Management
  • Memory Advisor Views
  • New Management Parameters

Session 2: INSTALLING AND CONFIGURING ORACLE DATABASE 11g

  • Install Oracle Database 11g
  • Deinstall Oracle Database 11g
  • The Database Configuration Assistant
  • Online Patching

Session 3: UPGRADING TO ORACLE DATABASE 11g

  • Upgrading to Oracle Database 11g Release 1 and 2
  • Upgrade the Time Zone File and Timestamp with Timezone Date
  • Oracle Parameter Changes
  • Online Dictionary View Changes

Session 4: OVERVIEW OF ORACLE RESTART

  • Control Oracle Restart
  • Use the srvctl Utility
  • Manually Add Components to the Oracle Restart Configuration

Session 5: NEW SECURITY FEATURES

  • Automatic Secure Configurations
  • Default Passwords
  • Case Sensitive Passwords
  • Profiles and the Password Verify Function
  • Default Auditing
  • Tablespace Master Key Re-key
  • Transparent Tablespace Encryption
  • Data Masking
  • Oracle SecureFile LOBs
  • Access Control Lists on Network Services
  • Oracle Secure File Masking
  • Security and OEM

Course Contents - DAY 2

Session 6: STORAGE ENHANCEMENTS

  • Use 4KB Sector Disks
  • Table Compression
  • Hybrid Columnar Compression
  • Segment Creation on Demand

Session 7: ADDM AND AWR NEW FEATURES

  • ADDM New Features
  • ADDM New Views
  • ADDM for RAC
  • Manage ADDM through DBMS_ADDM
  • Find Classifications
  • Directives
  • AWR New Features
  • Altered Retention of AWR Snapshots
  • AWR Baseline New Features
  • Adaptive Metric Thresholds

Session 8: NEW SCHEDULER FEATURES

  • Scheduler Automated Maintenance Tasks
  • Auto Task Architecture
  • Auto Task Dictionary Views
  • Use OEM to Manage Auto Task
  • Manage Auto Task Manually
  • The Auto Task Maintenance Windows

Session 9: SCHEMA MANAGEMENT NEW FEATURES

  • DDL Wait Option
  • Add Columns with a Default Value
  • Virtual Columns
  • Improved Online Index Creation and rebuild
  • Invisible Indexes
  • Read Only Tables

Session 10: APPLICATION DEVELOPMENT NEW FEATURES

  • SQL
  • New SQL*Plus Commands
  • Lock Table Parameter
  • Client Side Result Cache
  • Server Result Cache
  • Use Table Automation to Control Result Caching
  • Regular Expression Enhancements
  • Named Notation
  • PL/SQL
  • PL/SQL Function Cache
  • Automatic Subprogram Inlining
  • PL/SQL Scope
  • PL/SQL Native Compilation
  • Dynamic SQL in PL/SQL
  • Dynamic SQL and REF Cursors
  • Trigger Enhancements
  • Simple Integer Datatype
  • PL/SQL CONTINUE Statement
  • Natural Sequences

Course Contents - DAY 3

Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION

  • Automatic Block Corruption Reporting
  • Automatic Quarantine of Corrupt Redo Segments
  • Protection from Data Corruption
  • Improvements to Analyze Validate Structure
  • Proactive Monitoring with the Health Monitor

Session 12: RECOVERY MANAGER NEW FEATURES

  • Automatic Channel Failover
  • Parallel Backups
  • Compressed Backups
  • Improved Handling of Long Term Backups
  • Backup Failover of Archived Redo Logs
  • Archived Redo Log Deletion Policy
  • Undo Backup Optimization
  • Improved Block Media Recovery
  • Stored Scripts with Substitution Values
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup up Catalogs
  • Active Database Duplication
  • TSPITR Enhancements and Modifications

Session 13: DATA RECOVERY ADVISOR

  • Overview of the Data Recovery Advisor
  • Use the Data Recovery Advisor through OEM
  • Use the Data Recovery Advisor through the RMAN Command Line
  • Proactive Health Checks with the Validate Command
  • Data Recovery Advisor Dictionary Views

Session 14: FLASHBACK TECHNOLOGY

  • Flashback Transaction Backout
  • Flashback Transaction Wizard
  • Enterprise Manager Log Miner Interface
  • Oracle Total Recall
  • Flashback Data Archive Overview
  • Flashback Data Archive Architecture
  • Flashback Data Archive Workflow

Session 15: DATABASE REPLAY

  • Overview of Database Replay
  • The Database Replay Process
  • Capture Workload
  • PreProcess the Captured Workload
  • Replay Workload
  • Database Replay Usage
  • The DBMS_Workload Package

Course Contents - DAY 4

Session 16: DATA PUMP NEW FEATURES

  • Dump File Set Compression
  • Encryption Enhancements
  • Data Remapping
  • Rename Table
  • Dump File Overwrite
  • Partitioned Tables
  • The Transportable Parameter
  • The Data_Options Parameter
  • The exp Utility Deprecated
  • Data Pump Legacy Mode

Session 17: OVERVIEW OF DATA GUARD NEW FEATURES

  • Compression of Archived Redo Logs
  • Lost Write Detection
  • Higher Availability with Fast Start Failover Enhancements
  • Real Time Query Capable Physical Standby Database
  • Rolling Upgrades to Physical Standby
  • Block Change Tracking on a Physical Standby Database
  • SQL Apply Logical Standby
  • RMAN and Data Guard
  • Snapshot Standby Database
  • Clone a Running Database
  • Oracle Active Data Guard
  • Real Time Query Apply Lag Time

Session 18: ORACLE DATABASE ADVISORS

  • Repair Advisors and Fault Diagnostics
  • The SQL Repair Advisor
  • The SQL Access Advisor
  • The Streams Performance Advisor
  • The Advisor Views

Session 19: OVERVIEW OF ASM CHANGES AND NEW FEATURES

  • SYSASM Role
  • Disk Group Attributes
  • Fast Disk Resync
  • Preferred Mirror Read
  • Compatibility Settings
  • ASM Support for Variable Allocation Unit Sizes
  • Drop Diskgroup Force
  • The asmcmd Command Line Interface
  • New ASM Documentation
  • Oracle Database 11g Release 2 New Features

Course Contents - DAY 5

Session 20: NEW DIAGNOSTIC FEATURES

  • Oracle Database 11g Fault Diagnostic Automation
  • Automatic Diagnostic Workflow
  • Problems and Incidents
  • Incident Packaging Service
  • Temporary Tablespace Shrink
  • EM Support Workbench Overview

Session 21: PERFORMANCE TUNING NEW FEATURES

  • Improved Statistics Gathering
  • Real-Time SQL Monitoring
  • Monitoring and Tuning usage model
  • Setting up Notification rules
  • Using the Advisors
  • The SQL Performance Analyzer
  • Automatic SQL Tuning
  • Manual Creating and Use of SQL Tuning Sets
  • Intelligent Cursor Sharing
  • SQL Plan Management
  • Temporary Tablespace Shrink
  • Test Case Builder
  • SQL Monitoring in Oracle Database 11g R2
  • View Session Details
  • View the SQL Monitoring Report

Session 22: DATA WAREHOUSE AND BI NEW FEATURES

  • Partitioning Enhancements
  • Data Pump Single-Partition Imports
  • Materialized Views and Query Rewrite Enhancements
  • The PIVOT and UNPIVOT Clauses
  • Data Compression
  • Enhancements to the Degree of Parallelism
  • In Memory Parallel Query
  • System Managed Indexes for List Partitioning

Session 23: RESOURCE MANAGER CHANGES AND NEW FEATURES

  • I/O Calibration
  • Default Maintenance Plan
  • Built-In Resource Plans
  • Resource Manager Statistics in AWR
  • Resource Manager Plan Directive New Features
  • Instance Caging
See all of the available Technical Courses