14 November 2017 – SEMINAR EBR

On 14 November 2017, Romanian Oracle User Group prepared a new event dedicated to Oracle passionate professionals.

This seminar will cover a full day schedule and will present Edition Based Redefintion (EBR) – Oracle Database feature that permit upgrading applications with zero down-time.

Shot description: In general, patching or upgrading the artifacts in an Oracle Database that implement an application’s back end involves changing two or more functionally dependent objects.

Because each DDL autocommits, such changes inevitably imply that the system is mutually inconsistent once the patching begins and that its integrity is regained only when patching completes. Before EBR, your only option, therefore, was to take downtime.
EBR allows you to create a semantic copy of the live system within the same database so that you can make your changes to that while the live system remaims in interruped use. Of course, the quota-consuming data nust be mutually synchronized, transactionally.
EBR supports this too. This workshop explains how it all works.

Speaker: Bryn Llewellyn

Bryn is a “leading expert” in EBR. He was part of the team that did the requirements analysis (Oracle E-Business Suite was the commissioning customer). Then he was part of the team that did the conceptual design. He has been the Product Manager for EBR since before the GA of Oracle Database version 11.2 was announced at OpenWorld 2009. (This is the version that brought EBR.) And he continues to participate in conceptual design work with each new database release. He has presented on EBR an uncountable number of times, both at conferences and in bespoke web conf presentations for customers. And he has advised many customers about their adoption and deployment of EBR.
Bryn is an Oak Table member.

Agenda :

09:00 – 10:15 – The conceptual challenges implied by the “zero downtime application patching goal” – Bryn Llewellyn
10:15 – 10:30 – Coffee Break
10:30 – 12:00 – The core teaching: the edition, the editioning view, and the crossedition trigger. Readying the database to use EBR – Bryn Llewellyn

13:30 – 15:00 – Explaining the SQL statements that implement an EBR exercise – Bryn Llewellyn
15:00 – 15:15 – Coffee Break
15:15 – 16:00 – A Customer Story with EBR – Adina Samoila and Gabriela Huleai (Metro Systems)
16:00 – 17:30 – Completing the study of the code example. Final round of questions, discussion, and summary  – Bryn Llewellyn

The workshop is organized with logistic help of Oracle Romania and will take place at Oracle’s location, Floreasca Park, Ground Floor hall GF03.

You can subcribe for a place by sending an email with subject SeminarEBR-Inscriere to contact@rooug.ro with the Name, Company, Phone and Company Position or by filling the next form: