Randolf Eberle-Geist

Oracle Database Performance Expert

[Randolf Eberle-Geist @oracle_perf]

For those attending the IT Tage conference in Frankfurt and being interested in a guide to good index design for relational databases - consider coming to my talk at 1 pm local time. This talk will also be available online after the conference for those missing it.

#ITTage

[Randolf Eberle-Geist @oracle_perf]

I will talk tomorrow at the DOAG conference in Nuremberg 4:30 pm room "Shanghai" about a practical guide to good index design for relational databases - see you there!

#DOAG2023

[Randolf Eberle-Geist @oracle_perf]

Let me show in this talk you how you can make the most out of the available instrumentation in Oracle (Session Statistics, SQL Trace, Active Session History etc.) and what you can do in those cases where that instrumentation is not sufficient for understanding what is going on.

[Randolf Eberle-Geist @oracle_perf]

Please join me when I redo my talk "Oracle Advanced Troubleshooting" as part of the "Oracle Community Yatra (OCYatra) 2023 Replay" the upcoming Wednesday 12:30 to 13:30 India time.

https://t.co/8MRXhz5ni4

[Randolf Eberle-Geist @oracle_perf]

Nice little enhancement backported to the 19.19 Release Update: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES are now populated:

https://t.co/ocZliN39Op

[Randolf Eberle-Geist @oracle_perf]

Second day of my indexing seminar at DOAG Berlin - fully packed room with a great audience

[Randolf Eberle-Geist @oracle_perf]

First seminar day done - now chilling on a boat 🛥️ Thank you DOAG for organising this great evening event!

[Randolf Eberle-Geist @oracle_perf]

Back in town - Germany's biggest hotel.

[Randolf Eberle-Geist @oracle_perf]

On my way to Berlin - tomorrow morning starts my public seminar "Oracle Database Indexing" at the DOAG headquarters office :-)

[Randolf Eberle-Geist @oracle_perf]

Please join me when I redo my talk "Oracle 12c to 23c New Performance Features" as part of the "Oracle Community Yatra (OCYatra) 2023 Replay" the upcoming Wednesday 12:30 to 13:30 India time.

https://t.co/EsAyHpSvvX

[Randolf Eberle-Geist @oracle_perf]

My upcoming Oracle Database Indexing expert seminar (in German language) in cooperation with DOAG: There are still almost four weeks remaining, but just a few seats are left.
Thus, sign up quickly if you want to get one of the remaining few.

https://t.co/1Yfmwk0XM2

[Randolf Eberle-Geist @oracle_perf]

Nice little 21c / 23c enhancement which might have gone unnoticed - ALTER TABLE MOVE an entire partitioned heap table in a single command:

https://t.co/FrTcRdIndH

[Randolf Eberle-Geist @oracle_perf]

Playing around with 23c new features - here the unrestricted Direct Path loads. Some interesting / unexpected observations when using 23c FREE.

https://t.co/q5YAl5sBz1

[Randolf Eberle-Geist @oracle_perf]

Digitalbotschafter Rheinland Pfalz Fachtagung in Mainz - Multiplikatoren für Senioren

[Randolf Eberle-Geist @oracle_perf]

And scanning that much bigger temp segment is significantly slower than scanning the original compressed table. Even creating a compressed table upfront of that less than 50% data takes 13 minutes so net effect approx null.
So not much to gain on that front.

[Randolf Eberle-Geist @oracle_perf]

Table compression can add interesting twists - real customer story from the other day: So we spent 20 out of 60 minutes in that huge batch SQL on scanning the same big table 10 times constantly applying the same base filter each time reducing the data volume to less than 50%.

[Randolf Eberle-Geist @oracle_perf]

Surely we want to save some time on that so put that scan in a separate CTE and let it materialize referring to that CTE from then on. Net effect: 10 minutes slower 😐 Why: The table is using compression, materialising the less than 50% data results in twice the size temp segment

[All India Oracle Users Group (AIOUG) @AIOUG]

Memories from #OCYatra2023 #Hyderabad

New connections. Future technology. Inspiration. Lasting Memories. It all happened at #OCYatra2023

Watch this space for the next big event!

@Oracle @oracleugs @oracleace @Oracle_India @OracleDevs @oracledevcomm @OracleDatabase @OracleCloud #Oracle #Community #India

[Randolf Eberle-Geist @oracle_perf]

Our trip through India was surely a unique experience in many ways. I'm deeply grateful for all the kindness, awareness, open mind setting and enthusiasm of so many people we met.

[Randolf Eberle-Geist @oracle_perf]

Now that Im back again from India I need to say a big thank you to @sai_penumuru and @AIOUG for having me and my wife on the #OCYatra tour, supporting us first timers to India. In particular as some of us became sick due to food poisoning giving the organisers even more headaches