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
• New Memory Management Features
• Memory Advisor Views
• New Management Parameters

Session 2: INSTALLING ORACLE DATABASE 11g

• System Hardware requirements
• Overview of Oracle Grid Infrastructure
• Installing Oracle Database 11g Release 2
• The Database Configuration Assistant
• Database Templates
• 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
• Altered Parameter Behaviour
• Online Dictionary View Changes

Session 4: ADMINISTER A DATABASE

• Administrative Tools Available to a DBA
• Use Oracle Enterprise Manager to Manage a Database
• Stop and Start the EM Database Console
• Access Oracle Enterprise Manager
• Grant EM Administrative Privileges
• Control Oracle Restart
• Use the srvctl Utility
• Manually Add Components to the Oracle Restart Configuration

Session 5: NEW DATABASE STORAGE FEATURES

• Default Permanent Tablespace
• Rename a Tablespace
• The SYSAUX Tablespace
• Copy Files Using the Database Server
• Drop an Empty Datafile
• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Resource Estimation
• On Line Segment Shrink
• Proactive Tablespace Management
• Automatic Undo Retention
• Table Compression
• Hybrid Columnar Compression
• Segment Creation on Demand

Session 6: SECURITY ENHANCEMENTS

• Connect Role Change
• Default Passwords
• Automatic Secure Configurations
• Case Sensitive Passwords
• Profiles and the Password Verify Function
• Virtual Private Database Enhancements
• Auditing Enhancements
• OS Audit in XML Format
• Uniform Audit Trail
• Default Auditing in Oracle Database 11g
• Tablespace Master Key Re-key
• DBMS_CRYPTO
• Transparent Data Encryption
• Transparent Tablespace Encryption
• Data Masking
• Security and OEM

Session 7: AUTOMATIC DATABASE MANAGEMENT

• Automatic Workload Repository
• AWR 11g New Features
• Automatic Database Diagnostic Monitor
• ADDM 11g New Features
• ADDM Reports
• DBMS_ADVISOR Reports
• DBMS_ADVISOR Views
• Alerts

Session 8: AUTOMATING TASKS WITH THE SCHEDULER

• Scheduler Overview
• DBMS_SCHEDULER
• Scheduler Related Parameters
• Access Rights
• Create a Program
• Enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Resource Windows
• Window Group
• Monitoring and Logging
• AutoTask

Session 9: SCHEMA MANAGEMENT NEW FEATURES

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

Session 10: APPLICATION DEVELOPMENT NEW FEATURES

• Append, Create and Replace Extensions to Spool/Save
• SQL*Plus Errorlog Table
• Lock Table Parameter
• SQL Query Result Cache
• Client Side Result Cache
• PL/SQL Function Cache

Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION

• Automatic Block Corruption Reporting
• Automatic Quarantine of Corrupt Undo Segments
• Protection from Data Corruptions
• Improvements to ANALYZE ... VALIDATE STRUCTURE
• Proactive Monitoring with the Health Monitor

Session 12: BACKUP AND RECOVERY NEW FEATURES

• Recovery Through Reset Logs
• Changes to ALTER DATABASE ARCHIVELOG
• Recovery Manager Enhancements

Session 13: DATA RECOVERY ADVISOR

• Overview of Data Recovery Advisor
• Use the Data Recovery Advisor through the RMAN Command Line
• Run Pro-Active Health Checks with the Validate Command
• Use the Data Recovery Advisor through EM
• Automatic Diagnostic Repository
• Data Recovery Advisor Dictionary Views

Session 14: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT

• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• ASM Disk Failure
• ASM Data Dictionary Tables
• Migrate a Database to ASM Using RMAN
• The asmcmd Command Line Interface
• ASM File Access Control
• Use 4KB Sector Disks

Session 15: DATABASE REPLAY

• Overview of Database Replay
• The Database Replay Process
• Capture a Workload
• Pre-process the Captured Workload
• Replay the Workload
• Database Replay Usage
• The DBMS_WORKLOAD Package

Session 16: DATA PUMP

• The exp Utility Deprecated
• Introduction to Data Pump Import and Export
• Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Legacy Mode

Session 17: OVERVIEW OF DATA GUARD NEW FEATURES

• Apply Redo in Real Time
• Redo Transmission Enhancements
• New Standby Database Parameters
• ARCH Process Writes to Standby Redo Logs
• Changes to Standby Database Startups
• Logical Standby Database Enhancements
• Fast Start Failover Enhancements
• Archive Redo Log Compression
• Lost Write Detection
• Real Time Query Capable Physical Standby Database
• Rolling Upgrades to Physical Standby
• SQL Apply Logical Standby
• RMAN and Data Guard
• Snapshot Standby Databases
• Clone a Running Database
• Active Database Duplication
• Oracle Active Data Guard
• Real Time Query
• Block Change Tracking on a Physical Standby Database

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: FLASHBACK TECHNOLOGY

• Flashback Query
• Flashback Version Query
• Flashback Table
• Flashback Transaction Query
• Flashback Drop
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
• Enterprise Manager Log Miner Interface
• Flashback Data Archive
• Oracle Total Recall

Session 20: DIAGNOSTICS NEW FEATURES

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

Session 21: PERFORMANCE TUNING NEW FEATURES

• Rule Based Optimizer Obsolescence
• Automatic Statistics Collection
• Improved Statistics Gathering
• Direct SGA Access
• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Advisor
• Real-Time SQL Monitoring
• View the SQL Monitoring Report
• SQL Performance Analyzer
• Intelligent Cursor Sharing
• SQL Plan Management
• Temporary Tablespace Shrink
• Test Case Builder
• New Hints
• View Session Details

Session 22: DATA WAREHOUSE AND BI NEW FEATURES

• Partitioning Enhancements
• Materialized View and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression
• Parallel Query New Features
• Resource Manager New Features