Oracle Database 11g: New Features for Administrators

AS-SYSTEME Unternehmensberatung
In Stuttgart und Frankfurt Am Main

2.950 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
711 9... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

Beschreibung

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten: Dieser Kurs zeigt die neuen Change-Management Funktionen innerhalb von Oracle DB 11g. - Use the SQL Performance Analyzer. - Upgrade your database to 11g Release 1. - Record and replay workloads. - Use the automatic database diagnostic monitor. - Explore advanced RMAN capabilities. - Manage a flashback dat..
Gerichtet an: Data Warehouse-Administrator. Technischer Berater. Datenbankadministratoren.

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Frankfurt Am Main
Amperestrasse 6, D-63225, Hessen, Deutschland
auf Anfrage
Stuttgart
Wankelstraße 1, D-70563, Baden-Württemberg, Deutschland

Häufig gestellte Fragen

· Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen: - (AOR-2101) Oracle Database 10g: Neue Features fur Administratoren - (AOR-2103) Oracle Database 10g: Administration Workshop II Release 2

Themenkreis

Trainingsziel

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten:

Dieser Kurs zeigt die neuen Change-Management Funktionen innerhalb von Oracle DB 11g.

  • Use the SQL Performance Analyzer


  • Upgrade your database to 11g Release 1


  • Record and replay workloads


  • Use the automatic database diagnostic monitor


  • Explore advanced RMAN capabilities


  • Manage a flashback data archive


  • Use the data recovery advisor


  • Setup and use ASM


Teilnehmerkreis

Data Warehouse-Administrator

Technischer Berater

Datenbankadministratoren

Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen:

  • (AOR-2101) Oracle Database 10g: Neue Features fur Administratoren


  • (AOR-2103) Oracle Database 10g: Administration Workshop II Release 2


Im Vorfeld

AOR-2101: Oracle Database 10g: New Features für Administratoren Rel. 2

AOR-2103: Oracle Database 10g: Administration Workshop II Rel. 2

Im Anschluss

AOR-1009: Oracle Database 11g: SQL Tuning Workshop

Überblick über den Inhalt des Trainings

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


Storage Enhancements

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


Change Management Unit Overview

  • Change Management in Oracle Database 11g
  • Challenges Faced by DBAs When Performing Changes
  • Lifecycle of Change Management
  • Setting Up a Test Environment by Using the Snapshot Standby Database
  • SQL Performance Analyzer: Overview
  • Capturing the SQL Workload
  • SQL Performance Analyzer: Data Dictionary Views


SQL Plan Management

  • SQL Plan Management: Overview
  • SQL Plan Baseline: Architecture
  • Evolving SQL Plan Baselines
  • SQL Plan Selection
  • Possible SQL Plan Manageability Scenarios
  • SQL Performance Analyzer and SQL Plan Baseline Scenario
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy


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
  • Using the Capture Wizard
  • Packages and Procedures


Automatic SQL Tuning

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Maintenance Window Timeline
  • Automatic Tuning Process
  • DBA Controls
  • Automatic SQL Tuning Task
  • Automatic SQL Tuning: Fine Tune
  • Automatic SQL Tuning Considerations


Intelligent Infrastructure Enhancements

  • Automatic Workload Repository Baselines
  • Performance Monitoring and Baselines
  • Automated Maintenance Tasks
  • Resource Manager: New EM Interface


Performance Enhancements

  • ADDM Enhancements in Oracle Database 11g
  • Oracle Database 11g: Automatic Database Diagnostic Monitor for RAC
  • New ADDM Views
  • Automatic Memory Management: Overview
  • Oracle Database 11g Memory Parameters
  • Automatic Memory Parameter Dependency
  • Monitoring Automatic Memory Management


Partitioning and Storage-Related Enhancements

  • Oracle Partitioning
  • Partitioning Enhancements
  • Interval Partitioning
  • System Partitioning
  • Virtual Column-Based Partitioning
  • Reference Partitioning
  • Table Compression: Overview
  • SQL Access Advisor: Overview


Using RMAN Enhancements

  • RMAN: New Features
  • Optimized Backups
  • Parallel Backup and Restore for Very Large Files
  • Using RMAN Multisection Backups
  • Duplicating a Database
  • Managing Recovery Catalogs
  • Creating and Using Virtual Private Catalogs
  • Using RMAN Virtual Private Catalogs


Using Flashback and LogMiner

  • New and Enhanced Features for Flashback and LogMiner
  • Flashback Data Archive Overview: "Oracle Total Recall"
  • Flashback Data Archive: Architecture
  • Flashback Data Archive: Workflow
  • Guidelines and Usage Tips
  • Flashback Transaction Backout
  • Flashback Transaction Wizard
  • Using LogMiner


Diagnosability Enhancements

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


Using the Data Recovery Advisor

  • Repairing Data Failures
  • Data Recovery Advisor
  • Data Recovery Advisor RMAN Command-Line Interface
  • Best Practice: Proactive Checks
  • Setting Parameters to Detect Corruption


Security: New Features

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Using RMAN Security Enhancements


Oracle SecureFiles

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


Miscellaneous New Features

  • Foreground Statistics
  • Online Redefinition Enhancements
  • Minimizing Dependent Recompilations
  • Locking Enhancements
  • Invisible Index: Overview
  • SQL Query Result Cache: Overview
  • Adaptive Cursor Sharing: Overview
  • Temporary Tablespace Shrink



Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen