Retour en haut de la page

Oracle Database 11g - New Features for Administrators Release 2

5 jours - 35 heures

Objectifs

Install Oracle Grid Infrastructure Install Oracle Database 11g Release 2 Use Oracle Restart to manage components Use Automatic Storage Management (ASM) enhancements Implement table compression and hybrid columnar compression Implement data warehousing and partitioning enhancements Use the SQL Performance Analyzer Use SQL Plan Management and load SQL plan baselines Use Database Replay to record and replay workloads Set and manage Automatic SQL Tuning Use Resource Manager enhancements Use Enterprise Manager to monitor SQL commands Copyright © 2009, Oracle. Tous droits réservés. Page 1 Use the new and enhanced RMAN features Use Total Recall to create, protect, and use history data Use Data Pump in legacy mode Use Data Recovery Advisor

Participants

Administrateurs de base de données Administrateurs de data warehouse Consultant Technique Data Warehouse Administrator Database Administrators Ingénieurs support Responsables des ventes Sales Consultants Support Engineer Technical Consultant

Prérequis

Working knowledge of Oracle Database 10g

Pédagogie

La pédagogie est basée sur le principe de la dynamique de groupe avec alternance d'apports théoriques, de phases de réflexion collectives et individuelles, d'exercices, d'études de cas et de mises en situations observées. Formation / Action participative et interactive : les participants sont acteurs de leur formation notamment lors des mises en situation car ils s'appuient sur leurs connaissances, les expériences et mettront en œuvre les nouveaux outils présentés au cours de la session.

Profil de l’intervenant

Consultant-formateur expert. Suivi des compétences techniques et pédagogiques assuré par nos services.

Moyens techniques

Encadrement complet des stagiaires durant la formation. Espace d’accueil, configuration technique des salles et matériel pédagogique dédié pour les formations en centre. Remise d’une documentation pédagogique papier ou numérique à échéance de la formation.

Méthodes d’évaluation des acquis

Exercices individuels et collectifs durant la formation. La feuille d’émargement signée par demi-journée ainsi que l’évaluation des acquis de fin de stage sont adressées avec la facture.

Programme

Oracle Grid Infrastructure

Installing Oracle Grid Infrastructure for a Standalone Server

Creating an ASM Disk Group

ASM Cluster File System

ASM Dynamic Volume Manager

ASM File System Snapshot

SQL Plan Management

SQL Plan Management: Overview

Loading SQL Plan Baselines

Using the MIGRATE_STORED_OUTLINE Functions

Viewing Important Baseline SQL Plan Attributes

Loading a SQL Plan Baseline Automatically

Purging SQL Management Base Policy

Database Replay

Using Database Replay

Database Replay System Architecture

Supported Workloads

Database Replay Workflow in Enterprise Manager

Database Replay PL/SQL Procedures

Database Replay Data Dictionary Views

Automatic SQL Tuning

Automatic SQL Tuning in Oracle Database 11g

Selecting Potential SQL Statements for Tuning

Controlling the Automatic SQL Tuning Task

Configuring Automatic SQL Tuning

Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements

Using New Automatic Workload Repository Views

Creating AWR Baselines

Defining Alert Thresholds Using Static Baseline

Controlling Automatic Maintenance Tasks

Fixed Policy CPU Resource Management

Instance Caging

Scheduler Enhancements

Diagnosability Enhancements

Seting Up Automatic Diagnostic Repository

ADRCI: The ADR Command-Line Tool

Incident Packaging Service (IPS)

Using the Enterprise Manager Support Workbench

Invoking IPS Using ADRCI

Running Health Checks Manually

Using the SQL Repair Advisor

SQL Monitoring

SQL Monitoring in Oracle Database 11g Release 2

Viewing Session Details

Viewing the SQL Monitoring Report

Performance Enhancements

Using the DBMS_ADDM Package

New and Modified Views

Enabling Automatic Memory Management

Using New Statistic Preferences Features

Locking Enhancements

Adaptive Cursor Sharing

Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements

Online Redefinition Enhancements

Creating and Using Invisible Indexes

Backup and Recovery Enhancements

Using New SET NEWNAME Clauses

Optimized Backups

Using New Settings for Binary Compression

Enhancements to Database Duplication

Creating Archival Backups

TSPITR Enhancements and Modifications

Creating and Using Virtual Private Catalogs

Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump

Oracle Total Recall

Flashback Transaction Backout

Enterprise Manager LogMiner Interface

Data Pump Legacy Mode

Installation and Upgrade Enhancements

Installing Oracle Database 11g Release 2

Oracle Database Upgrade Enhancements

Online Patching

Upgrading Your Time Zone File and Timestamp with Time Zone Data

Data Recovery Advisor

Assessing Data Failures

Data Recovery Advisor RMAN Command-Line Interface

Data Recovery Advisor Views

Setting Parameters to Detect Corruption

Oracle Restart

Controlling Oracle Restart

Using the srvctl Utility

Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements

Seting up ASM fast mirror resync

Using ASM Scalability and Performance Enhancements

ASM Disk Group Compatibility

Using ASMCMD Extensions

ASM File Access Control

ASM Optimal Disk Placement

Storage Enhancements

Using 4 KB-Sector Disks

Using Table Compression

Hybrid Columnar Compression

SQL Access Advisor

Segment Creation on Demand

Data Warehouse and Partitioning Enhancements

Preprocessing Data for ORACLE_LOADER Access Driver in External Tables

Degree of Parallelism Enhancements

In-Memory Parallel Query

Partitioning Enhancements

System-Managed Indexes for List Partitioning

Oracle SecureFiles

Enabling SecureFiles Storage

Creating SecureFiles

Using SecureFile Compression

Accessing SecureFiles Metadata

Migrating to SecureFiles

Security and Networking Enhancements

Secure Password Support

Automatic Secure Configuration

Managing Default Audits

Setting Database Administrator Authentication

Transparent Data Encryption

Hardware Security Module

Tablespace Master Key Re-Key

Supporting IPv6 Address Notification

SQL Performance Analyzer

SQL Performance Analyzer: Overview

Using SQL Performance Analyzer

Using Enterprise Manager to Access SQL Performance Analyzer

SQL Performance Analyzer: PL/SQL Example

SQL Performance Analyzer: Data Dictionary Views

1189 log-509.pdf