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

Wichtige informationen

Tipologie Seminar
Niveau Anfänger
Ort An 2 Standorten
Dauer 5 Tage
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.

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
Beginn auf Anfrage
Lage
Frankfurt Am Main
Amperestrasse 6, D-63225, Hessen, Deutschland
Beginn auf Anfrage
Lage
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



User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen