ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 11g: Change Management Overview - Online Course

Format: Formation individualisée en ligne
Autres formats:
 
 

The adage that "Change is constant" holds true especially in the information technology world. While change can bring improvements, it also brings disruptions. This course 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 eStudy, 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 completing this eStudy, you can more effectively realize the positive benefits of database and application upgrades, while minimizing the negative side effects.

 
 

Compétences acquises

 
  • Set up snapshot standby for database testing

  • List the steps involved in Database Replay

  • Use SQL Performance Analyzer to ascertain performance gains following a database change

  • Describe and use the enhanced online table redefinition and materialized views

  • Use online table redefinition with materialized views and view logs

  • Make indexes invisible to test potential plan changes

 
  • Setup SQL Plan Manageability

  • Setup the Automatic Diagnostic Repository

  • Create an incident package to capture diagnostic data

  • Use Recovery Advisor to analyze critical SQL statement failures

  • Discuss the use of online patching to reduce system downtime

Qui peut en profiter

 
  • Application Developers

  • Data Warehouse Administrator

  • Data Warehouse Developer

 
  • Database Administrators

  • Technical Consultant

 
Buy This Training
Enroll For This Class
Oracle DB PeopleSoft Hyperion Ce cours autoformation est certifié par le .

Oracle University a nommé ExitCertified Partenaire de l’année 2011

Il y a une différence....découvrez-la.
Buy Training Now Ask A Question About This Training
Code: D52359GC10
Format: Formation individualisée en ligne
Durée:
Certifié par: Oracle
Frais d’inscription (CAD): 780$
Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
Recherchez des cours semblables
Cours connexes

 

Oracle Database 11g: Change Management Overview - Online Course Contenu détaillé

 
 
Introduction
  • Oracle Database 11g Focus Areas
  • New Features Overview eStudy
  • Change Management Overview eStudy
  • Management Automation
  • Self-Managing Database: The Next Generation
  • Suggested Additional Courses
  • Further Information
Realistic Testing: Setting Up the Test Environment
  • Objectives
  • Challenges When Performing Changes
  • Change Is the Only Constant
  • Life Cycle of Change Management
  • Using the Snapshot Standby Database
  • Benefits of Snapshot Standby
  • Creating a Snapshot Standby Database
  • Snapshot Standby DB Considerations
Realistic Testing: Using Database Replay
  • Managing Change in Oracle Database 11g
  • Why Use Database Replay?
  • Database Replay
  • Pre-Change Production System
  • Replay Data Divergence
  • Using EM for Workload Capture
  • Calibrating Replay Clients
  • Packages and Procedures
Realistic Testing: Using SQL Performance Analyzer
  • SQL Performance Analyzer: Overview Uses
  • Capture SQL Workload
  • Transport to a Test System
  • Build Before-Change Performance
  • Compare and Analyze Performance
  • Capturing the SQL Workload
  • SQL Performance Analyzer: Views
  • Exporting the SQL Workload
 
Provisioning Automation: Online Changes
  • Online Application Maintenance
  • Online Table Redefinition
  • Redefinition and Materialized View
  • Using PL/SQL to Redefine a Table
  • Fine-Grained Dependency Management
  • Usage Guidelines to Reduce Invalidation
  • Locking Tables Explicitly
  • Sharing Locks
Provisioning Automation: Using SQL Plan Management
  • SQL Plan Management: Overview
  • SQL Plan Baseline Architecture
  • Loading SQL Plan Baselines
  • Evolving SQL Plan Baselines
  • Important Baseline SQL Plan Attributes
  • SQL Performance Analyzer and SQL Plan Baseline Scenario
  • SQL Management Base: Purging Policy
  • SQL Plan Management Demonstration
Provisioning Automation: Diagnosing Problems
  • Oracle Database 11g Fault Management
  • Automatic Diagnostic Workflow
  • Automatic Diagnostic Repository
  • Location for Diagnostic Traces
  • Using ADRCI to View the Alert Log
  • Problems Versus Incidents
  • Oracle Configuration Manager
  • SQL Repair Advisor: Overview
Provisioning Automation: Installing Patches
  • Hot Patching: Overview
  • Installing a Hot Patch
  • Benefits of Hot Patching
  • Conventional Patching and Hot Patching
  • Hot Patching Considerations


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.
 
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI