Oracle AI Data Platform (AIDP): No-Nonsense Platform Overview
Oracle’s AI Data Platform (AIDP) is essentially an attempt to fix the biggest annoyance ...

While investigating a parallel query related performance problem in an 19.24 Oracle RACOne node database, I encountered ...

This post is about investigating a non obvious reason an INSERT running in parallel suddenly started taking longer to ...

A client was moving an Oracle 11.2.0.4 database from their data center to one of the major cloud providers' ...
In this post, I'll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the ...
There are various ways that we can approach the analysis of a past database performance problem. The initial steps ...
In this post I'll describe a problem which occurs when creating and using a database service name which starts with the ...

This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our ...

Introduction A client asked us to verify why an INSERT AS SELECT statement, which was part of a scheduled ETL job ...

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If ...
This blog post is about a scenario where a combination of a logon trigger performing DML operations at user login time ...

Background Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a ...