19c
-
Generating Table DDL in Oracle Database
Generating table DDL is a common requirement. Unfortunately it’s not quite common enough for me to…
-
DOAG 2021 gems: DBMS_XPLAN.COMPARE_PLANS
The most excellent #DOAG2021 conference ended last week. I have attended quite a few presentations and…
-
The performance story that didn’t turn out as one: a case of or-expansion and how the database mitigated the problem on its own
Recently I had a bit of time to study the effect of an optimizer query transformation,…
-
Deploying I/O intensive workloads in the cloud: Oracle Automatic Storage Management (ASM)
Over the past month I wrote a few posts about deploying I/O intensive workloads in the…
-
Resolving slight niggles of Enterprise Manager Express 19c
This page, should I remember I wrote it, hopefully addresses the slight niggles I have with…
-
Deploying I/O intensive workloads in the cloud: mdadm (aka Software) RAID
The final part of my “avoiding pitfalls with Linux Logical Volume Manager” (LVM) series considers software…
-
Deploying I/O intensive workloads in the cloud: LVM RAID
I recently blogged about a potential pitfall when deploying the Oracle database on LVM (Logical Volume…
-
Deploying I/O intensive workloads in the cloud: don’t fall for the LVM trap
I have been assessing the “best” storage option for Oracle databases deployed on Infrastructure as a…