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

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

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

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

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