Hotsos Symposium Speaker – Stephan Haisley

Mr. Haisley is a prior Hotsos Symposium presenter.

Biography

Stephan HaisleyStephan Haisley originally joined the UK Oracle Worldwide Support group in 1996 and has since worked in various technical support groups within Oracle. Currently he is a member of the Center Of Expertise, a small group within Oracles Support Services that specialize in complex problem resolution and internals of the database kernel. Stephan spends much of his time, when not teaching database internals classes or fixing customer issues, trying to figure out why Oracle works the way it does and then documenting it in a more readable manner.

Stephan has spoken at many Oracle conferences including RMOUG, UKOUG, IOUG-A and UTOUG, including the previous Hotsos Symposia.

Presentation Title

Streams Optimization and Diagnostics

Abstract

Oracle Streams was introduced in version 9.2 enabling the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another. The three main components of a Streams environment are the Capture, Propagation and Apply. Because of the interaction between Streams and the database, there are a number of areas that can suffer performance problems.

This presentation provides a methodology to follow when optimizing a Streams environment, demonstrating how to interpret the results of various data gathering tools such as AWR and STRMMON. Common performance problems will be shown along with the most effective ways of addressing them. A set of diagnostic best practices will also be presented when Streams is not behaving as expected.

Presentation Materials

Stephan's presentation materials may be found on the Hotsos portal. Please keep in mind that presentation materials are available online to attendees only.

Schedule

The speaker schedules can be found at the following links: