Oracle Warehouse Builder 10g: Administration NEW


--------------------------------------------------------------------------------
What you will learn

This hands-on course addresses specific administration features available in Oracle Warehouse builder 10g Release 2 (OWB). The course covers the administration tasks that may be performed during a data warehouse development process and also the administration tasks that are performed to maintain a fast and efficient Warehouse Builder system.

Students will learn strategies of administering an OWB environment. The course discusses strategies on how to configure and manage repositories, on backup and recovery, on how to manage the Control Center service, utilizing Real Application Clusters and more. Guided lab practices will give the students a hands-on opportunity to learn the administrative functionalities of OWB. This course is targeted for OWB administrators; not Warehouse Builder ETL programmers.

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



Audience
Data Warehouse Administrator
Database Administrators
Functional Implementer
Project Manager


Prerequisites
Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
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


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


--------------------------------------------------------------------------------

Course Topics

Components of OWB Architecture
Design Center client interface
Unified repository
Control Center and Control Center service
Installation requirements
Implementing a remote runtime

Preparing the Infrastructure
Configuring client, server, and database machines
Installing and Configuring Workflow
Installing and Configuring the Repository
Defining Repository owner and user(s)
Managing Control Centers and Locations
Managing Configurations

Configuration and Runtime Management
Multi-configuration concepts
Version management (Collections)
Applying Multi-configuration and version management to DEV-QA-Prod scenario
Runtime Platform Configuration
Preferences and settings for runtime
Runtime views and utilities
Public Views

Backup and Upgrade Strategies
Metadata Loader utilities
Database backups
Supporting upgrade from earlier OWB Releases
Patching Warehouse Builder
Time dimension changes
Managing Metadata changes-- through Snapshots

Security and Metadata Management
Applying security roles and privileges
Setting security policy for the repository
Metadata Security strategies
Enforcing Security Policies
Manage security in a multiple-user environment
Public repository objects
Enabling Security aspects of some Process Flow Editor activity types
Configuring Repository Browser environment

Performance Enhancement Methods
Configuring tablespaces, parallelism, PDML
Moving large volumes of data through Transportable Tablespaces
Scheduling ETL objects using Oracle Enterprise Manager or DB Scheduler
Multiple CPUs and Parallelism
Gathering Statistics
Setting properties for performance tuning

Diagnosing and Debugging
Using OMB administrative commands
Using OWB_HOME SQL scripts
Analyzing log files
Known errors and their solutions

Warehouse Builder in RAC Environment
Installing OWB into a RAC environment
Specific RAC parameters on the OWB and database sides
Monitoring and troubleshooting RAC nodes


--------------------------------------------------------------------------------

Suggested Next Courses
Oracle Database 10g: Implement and Administer a Data Warehouse


--------------------------------------------------------------------------------

D44810GC10

D44810GC10
Edition 1.0
January 2007
D49160

多谢版主！！！

lz真棒！

多谢,

请问和这个是不是同一文件?

http://www.itpub.net/viewthread.php?tid=901043

非常感谢!