دوره ها

Oracle Database 11g: Change Management Overview Seminar

• کد دوره : OR221
• مدت دوره : 8 ساعت
• شهریه : 0 ریال

پیش ثبت نام

برای این دوره ، کلاس عمومی برنامه ریزی نشده است.
لطفا پیش ثبت نام نمایید

What you will learn:

The adage that "Change is constant" holds true especially in the information technology world. While change can bring improvements, it also brings disruptions. This one day seminar focuses on the Oracle Database 11g Release 1 innovations which enable you to mitigate the chaos that database and application upgrades can wrought. In this course, you will learn about the features you can use to record production workloads then play them back in a test environment so that you can determine and eliminate potential issues before you deploy these changes to your production environment. The instructor lecture is supported by recorded product demonstrations. By attending this course, you can more effectively realize the positive benefits of database and application upgrades, while minimizing the negative side effects.

Learn to:

Make indexes invisible to test potential plan changes
Setup the Automatic Diagnostic Repository
Use Recovery Advisor to analyze critical SQL statement failures
Set up snapshot standby for database testing

Audience:

Database Administrators
Data Warehouse Administrator
Support Engineer
Database Designers
Technical Consultant
Project Manager

Prerequisites:

Required Prerequisites:

Oracle Database 11g : Administration Workshop II

Course Objectives:

Effectively use SQL Performance Analyzer
Use Database Replay
Setup and use SQL Plan Manageability
Create an incident package to capture diagnostic data
Use Online patching

Course Topics:

Introduction

Oracle Database 11g: Main Focus Areas
Oracle Database 11g: New Features Overview Seminar
Oracle Database 11g: Change Management Overview Seminar
Management Automation
Self-Managing Database: The Next Generation
Suggested Additional Courses
Further Information

Realistic Testing

Challenges Faced by DBAs When Performing Changes
Change Is the Only Constant
Life Cycle of Change Management
Setting Up the Test Environment by Using the Snapshot Standby Database
Benefits of Snapshot Standby
Using SQL to Create a Snapshot Standby Database
Using DGMGRL to Create a Snapshot Standby Database
Viewing Snapshot Standby Database Information

Realistic Testing

Managing Change in Oracle Database
Managing Change Effectively
Why Use Database Replay?
Database Replay
System Architecture: Capture
System Architecture: Processing the Workload
System Architecture: Replay
The Big Picture

Realistic Testing

SQL Performance Analyzer
Capturing the SQL Workload
Creating a SQL Tuning Set
Exporting the SQL Workload
Creating a SQL Performance Analyzer Task
Optimizer Upgrade Simulation
SQL Performance Analyzer: Task Page
Guided Workflow

Provisioning Automation: Performing Online Changes

Online Application Maintenance
Online Table Redefinition
Redefinition and Materialized View
Using PL/SQL to Redefine a Table
Fine-Grained Dependency Management
Minimizing Dependent PL/SQL Recompilation
More Precise Dependency Metadata
Managing Dependencies

Provisioning Automation: Using SQL Plan Management

SQL Plan Management: Overview
SQL Plan Baseline Architecture
Loading SQL Plan Baselines
Important Baseline SQL Plan Attributes
SQL Plan Selection
Possible SQL Plan Manageability Scenarios
SQL Performance Analyzer and SQL Plan Baseline Scenario
Automatic SQL Plan: Baseline Scenario

Provisioning Automation: Diagnosing Problems

Oracle Database 11g Fault Management
Ease Diagnosis: Automatic Diagnostic Workflow
Automatic Diagnostic Repository
ADRCI: ADR Command-Line Tool
V$DIAG_INFO
Location for Diagnostic Traces
Using ADRCI to View the Alert Log
Incident Packaging Service (IPS)

Provisioning Automation: Installing Patches

Hot Patching: Overview
Installing a Hot Patch
Benefits of Hot Patching
Conventional Patching and Hot Patching

۶ قدم تا موفقیت

مشتریان

شرکت ملی پالایش و پخش فرآورده های نفتی ایران

شرکت مخابرات ایران

بانک تجارت

سازمان راهداری و حمل و نقل جاده ای

شرکت پتروشیمی شازند

بانک مسکن

سایپا

بانک پارسیان

نیروی انتظامی جمهوری اسلامی ایران

موسسه مالی و اعتباری کارسازان آینده

ایساکو

مگفا

تعاونی اعتبار ثامن الائمه

همراه اول

شرکت داده ورزی سداد