Mathias Zarick

Oracle HA and replication, @Trivadis

[Franck Pachot @FranckPachot]

After the announcement of Aurora DSQL at re:Invent 2024 by AWS, many shared their thoughts on optimistic concurrency control. Instead, I’ve decided to tell you a story, written in SQL 🤓

https://t.co/88Q9NcJ7av

[Mathias Zarick @MathiasZarick]

@gunnarmorling @KonradHaefeli @Accenture Slides of the presentation in Nuremberg are also available here.
https://t.co/jKEV77Hx6u

[Konrad Haefeli @KonradHaefeli]

After a comparison of #Oracle #GoldenGate and #Debezium, @MathiasZarick @Accenture demoed the replication of #OracleDB to #PostgreSQL based on #Platys (ModernDataPlatform) at #DOAG2024

[Konrad Haefeli @KonradHaefeli]

Quiz at #DOAG2024 @Accenture booth. Many thx for joining, was fun 🥳
Congrats to the winner Neil @ChandlerDBA
👍. More Quiz to come next two days 😀

[Konrad Haefeli @KonradHaefeli]

Realtime Change Data Capture (#CDC) with #Oracle XStream presented by @MathiasZarick @Accenture at #DOAG2024. Comparing with other replication functionality.

[Julian Frey @JulianFreyCH]

@MathiasZarick will show us a little bit about CDC #DOAG2024

[Konrad Haefeli @KonradHaefeli]

First #DOAG2024 @DOAGeV session with @stefanoehrli @Accenture. Security supported by AI. Great slide with all #ORACLE Security features as overview.

[Mathias Zarick @MathiasZarick]

@getsomeual @debezium @crancran77 Still not a link, which is helpful

[Mathias Zarick @MathiasZarick]

Real-time data integration is something you like?
Join me at #DOAG2024
I'll present
"Real-Time Change Data Capture with Oracle XStream"
and
"Open Source Debezium as an Alternative to Oracle GoldenGate?"
Accenture booth: 3rd floor with Oracle ACEs, quizzes with prizes and drinks!

[Mathias Zarick @MathiasZarick]

@ora600pl @TanelPoder Great stuff in my collection for exactly those situations you described.

[Mathias Zarick @MathiasZarick]

as my AWS certification expires ... check out my Oracle Cloud Infrastructure 2023 Certified Architect Associate Certification! https://t.co/LA3dCUEANP #OracleCertified via @Oracle_Edu

[Mathias Zarick @MathiasZarick]

Read about real-time #replication between #Oracle and #PostgreSQL using #Debezium and #Kafka. #Platys helps to set up all the services.
https://t.co/OB2hPVoifm

[Ludovico Caldara @ludodba]

Writing when connected to a physical standby database? 🙀 There are good reasons to do it. Check my last blog post: https://t.co/lMPb4SUQ5u

[Ludovico Caldara @ludodba]

Did you know? In 21c (and consequently, 23c), we made DML redirection much faster for applications using it! #dataguard #db21c #db23c

[VLDB Bayliss @vldbb]

Automatic SPM is now available in #Oracle #Database #19c RU 19.22 EE https://t.co/my3GDodb6V

[Mathias Zarick @MathiasZarick]

@ora600pl @MikeDietrichDE You can also simply update sys.props$ to set the tz version that it wants to have. After import just change it back. Of course also unsupported. 😊

[Mathias Zarick @MathiasZarick]

@ludodba @monika_mitura @6056_peter If you put a counter in the loop and return its value at the end you can call it benchmark. 🤣

[Franck Pachot @FranckPachot]

IBM on MVCC databases in 2002: https://t.co/b9cq9QEk5b
20 years later:
🔴 all DBs provide MVCC (except Db2)
🟡 apps prefer explicit locking to isolation levels
🟢 all databases have different behavior on race condition

[Mathias Zarick @MathiasZarick]

@sridharreddyr I let #Debezium #Oracle connector with logminer adapter run for a while and it felt like an infinite loop of logminer dictionary builds until archiver was stuck.

[Mathias Zarick @MathiasZarick]

What a surprise...

[Biju Thomas @bijoosX]

Good news! Oracle Database 19c will waive the first and second years of Extended Support (EXS, ES) fees.
Premier Support (PS) ends on April 30, 2024, and waived Extended Support (ES) fees will be in effect from May 1, 2024, until April 30, 2026.