ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.

Email Training Course

Oracle Database 11g: New Features for Streams Seminar - LVC Release 2

Format: Instructor-Led Live Virtual Class
Other Formats:
 
 

In this course, students learn about the new Streams features and functionality in Oracle Database 11g Release 1 and Release 2.

These features include enhancements to usability and manageability functionality for administering an Oracle Streams environment. Changes and additions to Oracle Streams functionality, such as implementing synchronous capture, splitting and merging of streams, and comparing and converging data are discussed. Students see some of the new features and functionality in action through the use of viewlets.

Learn To:
  • Split and merge data
  • Compare and converge data
  • Perform synchronous capture
  • Describe Advanced Queuing (AQ) enhancements
  • Describe Oracle Database 11g Streams enhancements and new features

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not

 
 

Skills Gained

 
  • List and use Oracle Database 11g Streams enhancements and new features

  • Describe new features related to manageability and diagnosability

  • Describe and use Oracle Streams split and merge functionality

  • Describe usability enhancements

  • Compare and converge data

 
  • Implement synchronous capture

  • Describe Advanced Queuing enhancements

  • Configure XStream

  • View XStream in action

Who Can Benefit

 
  • Database Administrators

  • Support Engineer

 
  • Technical Administrator

Prerequisites

 
  • Oracle Database Administrator

 
  • Oracle Streams Administrator

 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion This course is taught by Certified Oracle instructors.

Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards

There is a difference....learn more.
Training Class Enrollment Ask A Question About This Training
Code: D60003GC10
Format: Instructor-Led Live Virtual Class
Length: 1
Certified By: Oracle
Tuition (CAD): $800
Browse Similar Training Classes
Related training classes

Sort Schedule By: 
No Course Dates There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
   
Request course date Request Course On-Site
 

Oracle Database 11g: New Features for Streams Seminar - LVC Release 2 Content Details

 
 
Oracle Streams New Features: Overview
  • Identifying Oracle Streams Processes
  • Oracle Streams Performance Advisor
  • Viewing Oracle Streams Topology
  • Configuring Oracle Streams with Enterprise Manager
  • Automated Alerts
  • Simplified Way to Restore Default Values for Parameters
  • Restoring default values for parameters
  • Message Tracking with DBMS_STREAMS_ADM.SET_MESSAGE_TRACKING
Using Manageability Enhancements
  • Describing and using capture enhancements, such as:
  • Recording Table Changes and KEEP_COLUMNS Declarative Transformation
  • Usability Enhancements, such as:
  • Support for XMLType, SecureFile LOBs, Flashback data archive and virtual columns
  • Support for Compressed Tables and TDE
  • Apply Enhancements, such as:
  • DML Statement Handler Type and SQL Generation
  • Diagnosability Enhancement
Using Combined Capture and Apply
  • Combined Capture and Apply (CCA) Requirements
  • Initiating the CCA Optimization
  • Verifying the Use of CCA in Enterprise Manager and via Command Line
  • Monitoring and managing an Oracle Streams environment with CCA
Splitting and Merging of Streams Destination
  • Automatic Split and Merge
  • Streams: Hub with Three Spokes
  • Split Streams: Unavailable Site
  • The SPLIT_STREAMS Procedure
  • Merge Streams: Original Configuration
  • DBMS_STREAMS_ADM Methods
  • Using MERGE_STREAMS_JOB
  • New DBA_RECOVERABLE_SCRIPT_HIST View
 
Comparing and Converging Data
  • Comparing Table Data
  • Creating a Comparison
  • Viewing the Differences in Data
  • Converging Database Objects
  • Performing Different Types of Comparisons
  • Purging Comparison Results
  • Dropping a Comparison
Implementing Synchronous Capture
  • Captured Changes
  • Configuring Synchronous Capture
  • Queues and Apply for Synchronous Capture
  • Using the DBMS_STREAMS_ADM and the DBMS_CAPTURE_ADM Package
  • Displaying the Tables and Viewing the Extra Attributes
  • Displaying the Queue and Rule Set
  • Dropping a Synchronous Capture
  • Listing Objects That Are Not Compatible with Synchronous Capture
Using Advanced Queuing Enhancements
  • Native Support for AQ in JDBC Driver
  • Viewing Subscriptions and Performance
  • Using the Scheduler
  • Scalable Notifications
  • Enhanced Messaging Gateway Agent
  • Creating an Agent
  • Configuring a Messaging Gateway Propagation Job
Configuring and Using XStream
  • Heterogeneous Data Sharing
  • XStream Architecture
  • XStream Out and XStream In
  • Position Order in an LCR Stream
  • Configuring an Outbound Server and an Inbound Server
  • XStream in Action - An Example
  • Monitoring XStream


  ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
  When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

There is a difference. Learn from the source.
 
Training Contacts  
   
Canada United States

Vancouver Training :: 604.633.3948
Victoria Training :: 1.866.328.3948
Calgary Training :: 403.291.2855
Edmonton Training :: 780.441.3948
Regina Training :: 1.866.328.3948
Toronto Training :: 416.487.3948
Ottawa Training :: 613.232.3948
Montreal Training :: 514.876.1666
Quebec City Training :: 514.876.1666

Sacramento Training :: 916.669.3970
San Francisco Training :: 415.975.3948
San Jose Training :: 408.288.3948
Las Vegas Training :: 1.800.803.3948
Phoenix Training :: 602.889.9350
Worldwide - 613.232.3948 Got Questions?
We are happy to help. Just email us with this form and we'll get back to you shortly.
   



(c) 2010 ExitCertified Corp. All rights reserved.


ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
 
Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
         
MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
  Apple Course, Leopard Training, Xsan Training