Oracle10g Streams and Advanced Queuing

PT5206
Summary
Oracle Streams AQ provides database integrated message queuing functionality. It is built on top of Oracle Streams and leverages the functions of Oracle Database so that messages can be stored persistently, propagated between queues on different computers and databases, and transmitted using Oracle Net Services and HTTP(S).
Prerequisites
Students should be Oracle DBA's with at least six months of experience as a DBA. Successful completion of Oracle9i or 10g courses Database Administration Fundamentals I and Database Administration Fundamentals II.
Duration
5 Days\Lecture & Lab
Audience
This course is intended for programmers who develop applications that use Oracle Streams AQ.
Topics
  • Introduction and Overview
  • Database Initialization Parameters
  • Design of a Streams/Advanced Queuing Application
  • Streams Capture Process
  • Streams Apply Process
  • Streams AQ Security
  • Streams Staging and Propagation
  • Streams Conflict Resolution
  • Transformations
  • Working with AQ$ Tables
  • Troubleshooting

Related Scheduled Courses