Oracle Warehouse Builder 10g: Administration

Seminarziel

Sie erlernen die administrativen Funktionen innerhalb des Oracle Warehouse Builder 10g Release2. Sie werden administrative Funktionen und Strategien anwenden, um ein schnelles und effizientes Warehouse Builder System zu warten.
Learn to: - Diagnose and debug errors (not mapping debugging) - Apply performance enhancement methods - Install and setup OWB in a RAC environment - Manage OWB security - Configure OWB for a multi-user environment - Manage configuration and runtime settings

Zielgruppe

Data Warehouse-Administratoren, Datenbankadministratoren, Projektmanager

Seminarinhalte

o Describe security and metadata management functionality o Demonstrate how to administer using OMB Plus commands and SQL scripts o Demonstrate how to troubleshoot common errors o Describe how OWB works in a RAC environment o Understand Warehouse Builder Architecture and Components o Describe Configuration and Runtime Management features o Demonstrate Backup and Upgrade methodology o Describe performance enhancements methods
Sachgebiete:

Components of OWB Architecture

Preparing the Infrastructure

Configuration and Runtime Management

Backup and Upgrade Strategies

Security and Metadata Management

Performance Enhancement Methods

Diagnosing and Debugging

Warehouse Builder in RAC Environment

Voraussetzungen

Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL Empfohlene Vorkenntnisse:
- OTN Oracle By Example (OBE): Introduction to OWB 10g Rel. 2 - Prior hands-on experience using an earlier version of OWB - "Oracle Warehouse Builder 10g: Implementation Part I"

Hinweis

The current version of this course is presented using OWB 10gR2, however this course is also suitable for OWB 11gR1 customers. The user interface differences between OWB 10gR2 and 11gR1 are very minor and hence are not included in this course''s lab practices.
Empfohlene weitere Ausbildung:
- "Oracle Database 10g: Data Warehouse Implementierung und Administration"