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

Follow-On Courses

• Oracle 11g SQL Performance Tuning
• Oracle 10g Application Server Administration

Administration and Course Materials

• Course Structure and Agenda
• Delegate and Trainer Introductions

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

Installing and Configuring Oracle Database 11g

• Installing Oracle Database 11g
• The Database Configuration Assistant
• Online Patching

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

Oracle Restart

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

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

Storage Enhancements

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

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

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

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

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

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

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

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

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

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

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

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

Oracle Database Advisors

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

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

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

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

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

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