Oracle Database 11g: New Features for Administrators

This course is already delivered, please contact us for the next available session tel:+357 22 44 14 92

Course Outline in PDF


This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

Who Should Attend:

This course is intended for:
•Database Administrators
•Sales Consultants
•Support Engineer
•Technical Consultant

At Course Completion:

•Implement manageability features to simplify database management
•Utilize database advisors to provide proactive database monitoring
•Increase data availability by using improved ASM, RMAN, and Flashback features.
•Use change management features to master database changes

Module 1:  Installation and Upgrade Enhancements
•Oracle Database 11g Installation: Changes
•Oracle Database 11g: Software Installation
•Oracle Database Upgrade Enhancements
•Upgrade Performance Enhancement
•Upgrade Process
•Oracle Database 11g Release 1: Upgrade Paths
•Database Upgrade Assistant (DBUA)
•Hot Patching: Overview

Module 2: Storage Enhancements
•ASM Fast Mirror Resync: Overview
•ASM Scalability and Performance Enhancements
•ASM Preferred Mirror Read: Overview
•ASM Scalability in Oracle Database 11g
•ASMCMD Extensions
•ASM Disk Group Compatibility

Module 3: Change Management Unit Overview
•Change Management in Oracle Database 11g
•Challenges Faced by DBAs When Performing Changes
•Lifecycle of Change Management
•SQL Performance Analyzer: Overview
•Capturing the SQL Workload
•SQL Performance Analyzer: Data Dictionary Views
•SQL Plan Management: Overview
•SQL Plan Baseline: Architecture
•Evolving SQL Plan Baselines
•Possible SQL Plan Manageability Scenarios
•SQL Performance Analyzer and SQL Plan Baseline Scenario
•Purging SQL Management Base Policy

Module 4: Database Replay
•System Architecture: Capture
•System Architecture: Processing the Workload
•System Architecture: Replay
•Pre-Change Production System
•Supported Workloads
•Database Replay Workflow in Enterprise Manager
•Packages and Procedures

Module 5: Automatic SQL Tuning
•Automatic SQL Tuning in Oracle Database 11g
•Selecting Potential SQL Statements for Tuning
•Maintenance Window Timeline
•Automatic Tuning Process
•Automatic SQL Tuning Task
•Automatic SQL Tuning Considerations

Module 6: Intelligent Infrastructure Enhancements
•Automatic Workload Repository Baselines
•Performance Monitoring and Baselines
•Automated Maintenance Tasks
•Resource Manager: New EM Interface

Module 7: Performance Enhancements
•ADDM Enhancements in Oracle Database 11g
•New ADDM Views
•Automatic Memory Management: Overview
•Oracle Database 11g Memory Parameters
•Monitoring Automatic Memory Management

Module 8: Partitioning and Storage-Related Enhancements
•Oracle Partitioning
•Partitioning Enhancements
•System Partitioning
•Reference Partitioning
•Interval Partitioning
•Table Compression: Overview
•SQL Access Advisor: Overview

Module 9: Using RMAN Enhancements
•RMAN: New Features
•Parallel Backup and Restore for Very Large Files
•Using RMAN Multisection Backups
•Managing Recovery Catalogs
•Using RMAN Virtual Private Catalogs

Module 10: Using Flashback and LogMiner
Lessons•New and Enhanced Features for Flashback and LogMiner
•Flashback Data Archive Overview: “Oracle Total Recall”
•Flashback Data Archive: Workflow
•Guidelines and Usage Tips
•Flashback Transaction Wizard
•Using LogMiner

Module 11: Diagnosability Enhancements
•Oracle Database 11g R1 Fault Management
•Ease Diagnosis: Automatic Diagnostic Workflow
•Location for Diagnostic Traces
•Automatic Diagnostic Repository
•Incident Packaging Service (IPS)
•Health Monitor: Overview
•Data Recovery Advisor

Module 12 &13: Using the Data Recovery Advisor & Security: New Features
•Repairing Data Failures
•Data Recovery Advisor
•Best Practice: Proactive Checks
•Secure Password Support
•Managing Default Audits
•Setting Database Administrator Authentication
•Transparent Data Encryption
•Hardware Security Module
•Using RMAN Security Enhancements

Module 14: Oracle Secure Files
•Managing Enterprise Information
•Problems with Existing LOB Implementation
•Oracle SecureFiles
•Shared I/O Pool
•Altering SecureFiles
•Accessing SecureFiles Metadata
•Migrating to SecureFiles
•SecureFiles Monitoring

Module 15: Miscellaneous New Features
•Foreground Statistics
•Online Redefinition Enhancements
•Minimizing Dependent Recompilations
•Locking Enhancements
•SQL Query Result Cache: Overview
•Adaptive Cursor Sharing: Overview
•Temporary Tablespace Shrink

sd sd sd sd sd sd sd sd sd sd sd sd