Connor McDonald

Patching just keeps getting easier

After attending a talk by Mike Dietrich at the DOAG conference, I was pleasantly surprised to hear that in 21c,

I’ve just got back from the DOAG conference, and what a fantastic event it was. I know I’m considered a

When the “STORE IN” clause is mentioned for partitioned tables, most people’s mind turn toward hash partitioning, because the usage

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

Here’s something to be careful with when it comes to using DBMS_REDEFINITION. Let’s start with the following scenario. I have

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple

Often when you are building a slides for a presentation you need to animate something on screen to show its

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.