TL;DR: DBMS_CLOUD.CREATE_EXTERNAL_TABLE creates an external table that reads Parquet directly from S3. Define the table once, query it with standard SQL. No data loading, no ETL. With S3 connectivity working (Part 1 and Part 2), this post shows how to create DBMS_CLOUD external tables over Parquet files in S3 and query them from Oracle 26ai.
Querying Parquet Files on S3 with DBMS_CLOUD in Oracle 26ai Read More »
TL;DR: DBMS_CLOUD fails with non-AWS S3 because it parses hostnames to select the signing algorithm and extract the AWS region. Fix: point s3.us-east-1.amazonaws.com at your endpoint via DNS, add it as a SAN on the endpoint’s TLS cert, and import the cert into an Oracle wallet. Full DBMS_CLOUD functionality, no file downloads. In Part 1,
Solving DBMS_CLOUD Connectivity with S3-Compatible Storage Read More »
TL;DR: DBMS_CLOUD requires valid HTTPS certificates with matching hostnames. Self-signed certs or HTTP-only? DBMS_CLOUD won’t work. This post shows what breaks and why. Version Note: This uses Oracle 26ai (23.26.1.0.0). SSL handling behavior changed in 23ai. On 19c/21c, sqlnet.ora settings like SSL_SERVER_DN_MATCH=NO still work, so self-signed certs may be viable with additional configuration. The steps
Connecting Oracle 26ai to S3-Compatible Object Storage Read More »
Finding which lakehouse architecture performs best on your infrastructure is expensive. Deploying a single stack on Kubernetes by hand takes days (ask me how I know). A different catalog, a different query engine, a different version, different resource profiles. The cost of the first deployment is high. The cost of repeating it for every permutation
Deploy, Score, and Compare Data Infrastructure on K8s with Lakebench Read More »
Part 2 of The Economics of Data Architectures in 2026 Part 1 surveyed seven architecture patterns, each with its own economics. Warehouse bets on centralization. Lakehouse bets on eliminating the ETL tax. Mesh bets on distributed ownership. And so on. But here’s the question nobody asks at selection time: what will it cost to leave?
Data Architectures and Change Management Read More »
Part 1 of The Economics of Data Architectures in 2026 The Modern Data Stack is Dead The Modern Data Stack (MDS) was never an architecture. It was a philosophy: best-of-breed tools, loosely coupled via APIs, separation of concerns. Fivetran for ingestion. Snowflake for storage. dbt for transformation. Looker for visualization. Buy the pieces, assemble yourself.
Data Architectures and Their Economics Read More »
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 »
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 »
