Oracle AI Data Platform (AIDP): No-Nonsense Platform Overview
Oracle’s AI Data Platform (AIDP) is essentially an attempt to fix the biggest annoyance ...
Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is "brand new," introduced in 12.2. I personally ...
One of the exclusive Exadata features is the Smart Flash Cache ( Oracle White Paper PDF). On a full rack, there is 5 TB ...

One of the most powerful features of the Oracle database is its ability to leverage multiple CPU cores across many RAC ...
In part one of this series on Oracle Parallel Query Hints, I looked at PQ_DISTRIBUTE, and part two was about ...
I gave this talk at the UKOUG, and I have received a few requests to post the slides online. Instead of just posting ...
Welcome to part 5 of the series.
The Mechanics of PQ_REPLICATE in Oracle 12.2 In part 1 of this series, we talked about the basic mechanics of the ...
While experimenting with Auto DOP (parallel_degree_policy) in Oracle 12c, I stumbled upon a highly effective (and ...
It's one of those hints that you've heard about many times, but all the information is scattered, and finding what you ...
In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE can change the data distribution method across ...
Problem Statement I was installing RAC, and during the clusterware install I picked up the wrong interfaces for public ...
Very often when reading data, we need to locate the most current record for a set of conditions. One typical example is ...
One of the biggest selling features of Oracle's flagship engineered system - Exadata - is the storage offloading ...
Introduction Ever wished the listener.log file was a table in the database? Wish no more! About three years ago, I sent ...
Just recently I got a call from a developer. He had a table with a primary key populated by a sequence, a timestamp ...
My apologies — there will be no broccoli in this post. Introduction Many people would like to know how well their ...
I got to troubleshoot an amazing situation a few weeks ago. I think, we can all agree that assuming we are on a ...
Oracle 11g has a new performance enhancement when adding columns. In the pre-11g releases, adding a new not null column ...
This is a fascinating look into storage architecture! It perfectly illustrates that "more hardware" doesn't always ...
Backstory A client asked me, “How can I move a table to another schema in Oracle?” The quick answer I gave him is, “not ...
Linux is a wonderful operating system. However there are a number of things that one needs to do to make sure it runs ...
Oracle Exadata V2 is a very well balanced database machine combined with smart and innovative software. One of these ...
So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy ...
Background For the past few months I’ve been using a query that I refer to as “ash report – recent spike”. That’s the ...