Andrew Sillifant

How to Avoid Misconfiguring Oracle ASM with Multipath SAN Storage

I installed Oracle RAC 19c on a two-node cluster with Pure Storage FlashArray backend. Four 32Gb Fibre Channel HBAs per node. 24 paths per LUN. Hardware capable of 12+ GB/s throughput. Yet my benchmarks topped out at 3.2 GB/s. This post explains the mistake I made, how I found it, and how I fixed it. […]

How to Avoid Misconfiguring Oracle ASM with Multipath SAN Storage Read More »

Installing Oracle Database 19c RAC on OEL 8: Four Traps

I recently built a two-node Oracle RAC 19c cluster on Oracle Linux 8.10 with Pure Storage FlashArray backend. The hardware was solid, the network was configured, the storage was presented. What should have been a straightforward installation turned into a four-hour troubleshooting session because of issues that aren’t documented in Oracle’s installation guides. This post

Installing Oracle Database 19c RAC on OEL 8: Four Traps Read More »

Demystifying the Analytics Market in 2025

This is the third in my series analyzing data-centric markets. See also: Demystifying the Database Market in 2025 and Demystifying the Data Governance Market in 2025. It’s interesting how major vendors position themselves now, none of them lead with “analytics”. Databricks calls itself “the Data and AI company.” Snowflake is “the AI Data Cloud.” dbt

Demystifying the Analytics Market in 2025 Read More »

Oracle Database Support for HammerDB-Scale

Oracle ranks #1 on the DB-Engines database popularity ranking, ahead of MySQL, SQL Server, and PostgreSQL. Running Oracle benchmarks alongside SQL Server in my day-to-day testing made perfect sense from the start, but HammerDB-Scale v1.0 focused on getting SQL Server working properly first. Version 1.1 adds Oracle support with the same parallel orchestration framework that

Oracle Database Support for HammerDB-Scale Read More »

Schrödinger’s dNFS: The Empty Row Mystery

You will end up here: v$dnfs_servers returns no rows. You’ve checked everything. The library is linked. The alert log shows dNFS loaded. Your oranfstab is syntactically perfect. The NFS mounts are there. And you’re convinced it’s broken, I was too. I spent three hours proving dNFS was configured correctly while simultaneously proving it wasn’t working.

Schrödinger’s dNFS: The Empty Row Mystery Read More »

Stress Testing Consolidated Platforms with Database Workloads

Your storage vendor claims 500K IOPS. Your server vendor promises 128 cores of “enterprise-grade performance.” Your hypervisor can “easily handle” 50 VMs. Your network fabric has “plenty of headroom.” Then you consolidate eight production databases onto the platform and everything falls over at 3 AM on a Tuesday. What happened? Nobody actually tested what happens

Stress Testing Consolidated Platforms with Database Workloads Read More »