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
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
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.
aioug.org/events/advanced-or…
1
3
323
Nice little enhancement backported to the 19.19 Release Update: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES are now populated:
oracle-randolf.blogspot.com/…
First seminar day done - now chilling on a boat 🛥️ Thank you DOAG for organising this great evening event!
3
113
On my way to Berlin - tomorrow morning starts my public seminar "Oracle Database Indexing" at the DOAG headquarters office :-)
9
418
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.
aioug.org/events/oracle-12c-…
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.
shop.doag.org/event/id.148.e…
Nice little 21c / 23c enhancement which might have gone unnoticed - ALTER TABLE MOVE an entire partitioned heap table in a single command:
oracle-randolf.blogspot.com/…
94
Playing around with 23c new features - here the unrestricted Direct Path loads. Some interesting / unexpected observations when using 23c FREE.
oracle-randolf.blogspot.com/…
6
161
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%.
1
2
99
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
1
1
65
Randolf Eberle-Geist retweeted
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
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.
4
85
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
96








