Training & Certifications

Oracle Database 11g: New Features for Administrators DBA Release 2

This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities.

It ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Topics covered include: the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance and strengthening security. Expert Oracle University instructors will also review several other areas that are of particular interest to database administrators.

Program Objectives

At the end of the program, the participants will be able to :

  1. Install Oracle Grid Infrastructure
  2. Install Oracle Database 11g Release 2
  3. Use Oracle Restart to manage components
  4. Use Automatic Storage Management (ASM) enhancements
  5. Implement table compression and hybrid columnar compression
  6. Implement data warehousing and partitioning enhancements
  7. Use the SQL Performance Analyzer
  8. Use SQL Plan Management and load SQL plan baselines
  9. Use Database Replay to record and replay workloads
  10. Set and manage Automatic SQL Tuning
  11. Use Resource Manager enhancements
  12. Use Enterprise Manager to monitor SQL commands
  13. Use the new and enhanced RMAN features
  14. Use Total Recall to create, protect, and use history data
  15. Use Data Pump in legacy mode
  16. Use Data Recovery Advisor

Target Audience

This program is aimed for Data Warehouse Administrator, Database Administrators, Sales Consultants, Support Engineer, and Technical Consultant.

Duration

This program is 5 days of intensive training class.

Requirement

Participants are required to have working knowledge of Oracle Database 10g. It is recommended that participants also have taken Oracle Database 10g: Administration Workshop I Release 2 and Oracle Database 10g: Administration Workshop II Release 2.

Program Modules

Module 1 : Oracle Grid Infrastructure
  1. Installing Oracle Grid Infrastructure for a Standalone Server
  2. Creating an ASM Disk Group
  3. ASM Cluster File System
  4. ASM Dynamic Volume Manager
  5. ASM File System Snapshot

Module 2 : Installation and Upgrade Enhancements
  1. Installing Oracle Database 11g Release 2
  2. Oracle Database Upgrade Enhancements
  3. Online Patching
  4. Upgrading Your Time Zone File and Timestamp with Time Zone Data

Module 3 : Oracle Restart
  1. Controlling Oracle Restart
  2. Using the srvctl Utility
  3. Manually Adding Components to the Oracle Restart Configuration

Module 4 : ASM Enhancements
  1. Seting up ASM fast mirror resync
  2. Using ASM Scalability and Performance Enhancements
  3. ASM Disk Group Compatibility
  4. Using ASMCMD Extensions
  5. ASM File Access Control
  6. ASM Optimal Disk Placement

Module 5 : Storage Enhancements
  1. Using 4 KB-Sector Disks
  2. Using Table Compression
  3. Hybrid Columnar Compression
  4. SQL Access Advisor
  5. Segment Creation on Demand

Module 6 : Data Warehouse and Partitioning Enhancements
  1. Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  2. Degree of Parallelism Enhancements
  3. In-Memory Parallel Query
  4. Partitioning Enhancements
  5. System-Managed Indexes for List Partitioning

Module 7 : Oracle SecureFiles
  1. Enabling SecureFiles Storage
  2. Creating SecureFiles
  3. Using SecureFile Compression
  4. Accessing SecureFiles Metadata
  5. Migrating to SecureFiles

Module 8 : Security and Networking Enhancements
  1. Secure Password Support
  2. Automatic Secure Configuration
  3. Managing Default Audits
  4. Setting Database Administrator Authentication
  5. Transparent Data Encryption
  6. Hardware Security Module
  7. Tablespace Master Key Re-Key
  8. Supporting IPv6 Address Notification

Module 9 : SQL Performance Analyzer
  1. SQL Performance Analyzer: Overview
  2. Using SQL Performance Analyzer
  3. Using Enterprise Manager to Access SQL Performance Analyzer
  4. SQL Performance Analyzer: PL/SQL Example
  5. SQL Performance Analyzer: Data Dictionary Views

Module 10 : SQL Plan Management
  1. SQL Plan Management: Overview
  2. Loading SQL Plan Baselines
  3. Using the MIGRATE_STORED_OUTLINE Functions
  4. Viewing Important Baseline SQL Plan Attributes
  5. Loading a SQL Plan Baseline Automatically
  6. Purging SQL Management Base Policy

Module 11 : Database Replay
  1. Using Database Replay
  2. Database Replay System Architecture
  3. Supported Workloads
  4. Database Replay Workflow in Enterprise Manager
  5. Database Replay PL/SQL Procedures
  6. Database Replay Data Dictionary Views

Module 12 : Automatic SQL Tuning
  1. Automatic SQL Tuning in Oracle Database 11g
  2. Selecting Potential SQL Statements for Tuning
  3. Controlling the Automatic SQL Tuning Task
  4. Configuring Automatic SQL Tuning
  5. Using the PL/SQL Interface to Generate Reports

Module 13 : Intelligent Infrastructure Enhancements
  1. Using New Automatic Workload Repository Views
  2. Creating AWR Baselines
  3. Defining Alert Thresholds Using Static Baseline
  4. Controlling Automatic Maintenance Tasks
  5. Fixed Policy CPU Resource Management
  6. Instance Caging
  7. Scheduler Enhancements

Module 14 : Diagnosability Enhancements
  1. Seting Up Automatic Diagnostic Repository
  2. ADRCI: The ADR Command-Line Tool
  3. Incident Packaging Service (IPS)
  4. Using the Enterprise Manager Support Workbench
  5. Invoking IPS Using ADRCI
  6. Running Health Checks Manually
  7. Using the SQL Repair Advisor

Module 15 : SQL Monitoring
  1. SQL Monitoring in Oracle Database 11g Release 2
  2. Viewing Session Details
  3. Viewing the SQL Monitoring Report

Module 16 : Performance Enhancements
  1. Using the DBMS_ADDM Package
  2. New and Modified Views
  3. Enabling Automatic Memory Management
  4. Using New Statistic Preferences Features
  5. Locking Enhancements
  6. Adaptive Cursor Sharing
  7. Using Table Annotation to Control Result Caching

Module 17 : Application Maintenance and Upgrade Enhancements
  1. Online Redefinition Enhancements
  2. Creating and Using Invisible Indexes

Module 18 : Backup and Recovery Enhancements
  1. Using New SET NEWNAME Clauses
  2. Optimized Backups
  3. Using New Settings for Binary Compression
  4. Enhancements to Database Duplication
  5. Creating Archival Backups
  6. TSPITR Enhancements and Modifications
  7. Creating and Using Virtual Private Catalogs
  8. Introduction to Oracle Secure Backup Cloud Module

Module 19 : Flashback Technology, LogMiner, and Data Pump
  1. Oracle Total Recall
  2. Flashback Transaction Backout
  3. Enterprise Manager LogMiner Interface
  4. Data Pump Legacy Mode

Module 20 : Data Recovery Advisor
  1. Assessing Data Failures
  2. Data Recovery Advisor RMAN Command-Line Interface
  3. Data Recovery Advisor Views
  4. Setting Parameters to Detect Corruption
Scroll to Top