Oracle Database 11g New Features Seminar — A 1-Day Course

 Open Public Course Closed In-House Course

Synopsis

This seminar is designed to give delegates an appreciation of the new features available in Oracle Database 11g and of how these features may affect current Oracle installations.

Objectives

On completion of this course, delegates will be able to:

• Installation changes
• Upgrade issues
• Enterprise Manager changes
• Hot patching
• SQL new features
• PL/SQL new features
• New memory management features
• Database Replay to capture, process and replay a workload
• ASM improvements
• The Data Recovery Advisor and Flashback
• Transaction management using Flashback and LogMiner
• RMAN new features
• Data Guard improvements
• Performance tuning new features
• New security features
• New schema management functionality
• Data warehousing enhancements
• Miscellaneous new features

Suitable For

This course is intended for:

• Oracle professionals who need an understanding of Oracle Database 11g new features.

Prerequisites

Before attending this course, delegates should have an appreciation of the features available in an Oracle Database 10g database.

Publicly scheduled dates, locations, and prices

Outline Course Contents

New Management Features

• Automatic Diagnostic Repository (ADR)
• Parameter file management changes
• Automatic Memory Management

Installing Iracle Database 11g

• Installing Oracle Database 11g
• The DBCA
• Online patching

Upgrade to Oracle 11g

• Changes in 11g
• Upgrade to Oracle Database 11g
• New parameters
• Deprecated parameters
• Obsolete parameters

Database Security Enhancements

• Case sensitive passwords
• Default password
• Audit
• Password verify function
• Transparent tablespace encryption
• Fine grained access to database network services
• Data masking
• Securefile LOBs
• Security and OEM

ADDM and awr new features

• ADDM new features
• AWR new features

New Scheduler Features

• Auto Task overview
• Auto Task architecture
• Auto Task dictionary views
• Use OEM to manage Auto Task
• Manage Auto Task manually
• The Auto Task maintenance window

Schema Management New Features

• DDL wait option
• Add columns with default value
• Virtual columns
• Invisible indexes
• Read only tables

Application Development New Features

• New SQL*Plus commands
• Lock table parameter
• Client side caching
• Server result cache
• Named notation
• PL/SQL function cache
• PL/SQL native compilation
• Natural sequences
• When Others Then Null
• Create trigger as enabled or disabled
• Compound triggers
• Create trigger follows clause
• PL/SQL Continue statement

New and Enhanced Utilities Preventing and Detecting 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

RMAN enhancements

• Automatic channel failover
• Parallel backups
• Improved handling of long-term backups
• Backup failover for archived redo logs
• Archived redo log deletion policy
• Undo backup optimization
• Improved block corruption detection
• Improved block media recovery
• Substitution variables
• Compressed backups
• Virtual private catalogs
• Merge catalogs
• Backup a recovery catalog

Data Recovery Advisor

• Data Recovery Advisor overview
• DR through the RMAN command line
• Use DRA through OEM

Flashback data archive

• Flashback history
• Flashback transaction backout
• Transaction management with LogMiner and Flashback Data Archive
• LogMiner Interface in OEM
• Flashback Archive
• Setup Flashback Archive
• Flashback Archive dictionary views
• Flashback query

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 Packages

Data Pump New Features

• The exp utility deprecated
• Dump file set compression
• Encryption enhancements
• Rename table
• Dumpfile overwrite
• Partitioned tables
• The transportable parameter
• The data options parameter

Standby Database

• RMAN duplicate database
• Snapshot standby database
• Real time query
• Lost write protection

Oracle Database Advisors

• Repair advisors and fault diagnostics
• The SQL Repair Advisor
• The SQL Access Advisor
• The Streams Performance Advisor
• New DBA Advisor views

Asm Changes and New Features

• SYSASM role
• Disk group attributes
• Fast disk resync
• Preferred mirror read
• Support for variable extent sizes
• Drop diskgroup force
• Metadata backup and restore

Diagnostics New Features

• Fault diagnostic automation
• Automatic diagnostic workflow
• Problems and incidents
• Incident packaging service
• EM Support Workbench

Performance tuning new features

• Improved statistics gathering
• Real time SQL monitoring
• SQL Performance Analyzer
• Intelligent cursor sharing
• SQL Plan management
• Temporary tablespace shrink
• Test Case Builder

New Data Warehouse and BI Features

• Partitioning enhancements
• Materialized view enhancements
• Query rewrite enhancements
• PIVOT and UNPIVOT commands
• Data compression

Resource Manager Changes and New Features

• I/O calibration
• Resource Manager new features
• Default maintenance plan
• New built in plans
• Resource Manager statistics in AWR