Oracle Database 12c: Change Management Overview Seminar

– Introduction
— Oracle Database 12c: Main Focus Areas
— Oracle Database 12c: New Features Overview Seminar
— Oracle Database 12c: 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
— Hot Patching Considerations