Oracle Database 11g for Experienced 10g Database Administrators — A 5-Day Course

 Open Public Course Closed In-House Course

Synopsis

This course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g. The course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g. Database administrators will gain a practical understanding of the new features of Oracle Database 11g and how these can be implemented in their current Oracle installations.

Objectives

On completion of this course, delegates will have knowledge of:

• Installing Oracle Database 11g Software
• Creating an Oracle Database Using New Features
• Upgrading a Database to 11g Release 1
• Hot Patching
• Using SQL and PL/SQL New Features
• Using New Memory Management Features
• Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Transaction Management using Flashback and LogMiner
• Using RMAN New Features
• Using Data Pump Data Compression
• Using Performance Tuning New Features
• Using New Security Features
• Using New Schema Management Functionality
• Using AutoTask
• Using Data Warehouse and BI New Features

Suitable For

This course is intended for:

• Database administrators who need to update their current Oracle Database 10g skills to create, administer, monitor, backup and support Oracle Database 11g.

Prerequisites

Delegates should have a good understanding of Oracle Database 10g administration.

Publicly scheduled dates, locations, and prices

Outline Course Contents

Administration and Course Materials

• Course Structure and Agenda
• Delegate and Trainer Introductions

New Management Features

• Log File Changes
• Parameter File Management Changes
• Automatic Memory Management
• Memory Advisor Views
• New Management Parameters

Installing and Configuring Oracle Database 11g

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

Upgrading to Oracle Database 11g

• Upgrading to Oracle Database 11g
• Oracle Parameter Changes
• Online Dictionary View Changes

New Security Features

• Default Passwords
• Case Sensitive Passwords
• Profiles and the Password Verify Function
• Default Auditing
• Transparent Tablespace Encryption
• Data Masking
• Oracle SecureFile LOBs
• Access Control Lists on Network Services
• Oracle Secure File Masking
• Security and OEM

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
• 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

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 Data Archive

• Flashback Transaction Backout
• Flashback Transaction Wizard
• 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 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
• SQL Apply Logical Standby
• RMAN and Data Guard
• Snapshot Standby Database
• Clone a Running Database

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
• New asmcmd Commands
• New ASM Documentation

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

Data Warehouse and BI New Features

• Partitioning Enhancements
• Extended Composite Partitioning
• Interval Partitioning
• System Partitioning
• Reference Partitioning
• Partition Advisor
• Virtual Column-Based Partitioning
• Data Pump Single-Partition Imports
• Materialized Views and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression

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