When Oracle moved to the new Oracle database release model in 2018, some changes were introduced with it. I just realized that I haven’t blogged about it (even though I
Did You Know #37 – Backup the Standby DatabaseDid You Know #37 – Backup the Standby Database
This post is dedicated to Pieter Van Puymbroeck. When using a physical standby database, you can use RMAN to backup the standby database instead of the primary. You can backup
Another Loss to the Oracle CommunityAnother Loss to the Oracle Community
I can’t believe I’m writing another post like this… After the passing of Joel in May, last week our community got bad news again: Pieter Van Puymbroeck passed away. Pieter
Shrink Table and Fragmentation in Oracle, Part 2Shrink Table and Fragmentation in Oracle, Part 2
This is the second part of the article, in the previous part I explained how extent management and shrink table works. In this post I’ll dive into a problem that
Shrink Table and Fragmentation in Oracle, Part 1Shrink Table and Fragmentation in Oracle, Part 1
This is an article that was published in the past, however, it’s not available anymore so I decided to post it here. Fragmentation is a common issue which we try
The Oracle Community Has Lost a Great Person This WeekThe Oracle Community Has Lost a Great Person This Week
I haven’t been very active on my blog lately. I’ve been too preoccupied with many different projects and things I’ve been working on, but since I’ve heard the news I’ve
Checking SQL Progress in OracleChecking SQL Progress in Oracle
Checking an SQL statement progress is never easy. There are so many parameters that affect your execution time and estimates are never correct. So in this post I’ll mention a
The MASH Program – Speaker MentoringThe MASH Program – Speaker Mentoring
As I mentioned in my post from early February (the one about “Beyond Tech Skills” podcast), I haven’t written many posts on my blog lately. This is because I’ve been
Oracle SEHA – Failover When VIP Goes DownOracle SEHA – Failover When VIP Goes Down
Lately I’ve been writing about Standard Edition High Availability (SEHA). After publishing my introduction post about SEHA, I got a comment from Purav with a case I didn’t cover in
A New Project – The “Beyond Tech Skills” PodcastA New Project – The “Beyond Tech Skills” Podcast
I’m very excited to announce a new project that I’ve been working on for a few months now, the “Beyond Tech Skills” podcast. If you follow my blog you’ve probably