@uptimearchitect

Uptime Architect

@uptimearchitectJoined June 2026

Independent, vendor-neutral Oracle reliability & performance — RAC, Data Guard, tuning, OCI/Azure

Website

About

Nothing here yet.

Available for

Nothing here yet.

Uptime Architect's blogs

Oracle reliability & performance engineeringuptimearchitect.hashnode.dev18 posts

Articles Comments

Recently published

UAUptime Architectuptimearchitect.hashnode.dev2h ago · 14 min read

Oracle Flashback: Undo at the Database Level

Someone runs UPDATE accounts SET balance = 0 and forgets the WHERE. Commits it. A thousand balances are gone. The instinct is to reach for the backup — find last night's copy, restore it somewhere, ex

UAUptime Architectuptimearchitect.hashnode.dev4d ago · 15 min read

Oracle Transparent Data Encryption: Prove the Datafile Is Unreadable

"The data is encrypted at rest." Everyone says it. Almost nobody checks it. It goes in the compliance questionnaire, the auditor ticks the box, and the actual bytes on disk stay a mystery until the da

UAUptime Architectuptimearchitect.hashnode.devAug 19 · 14 min read

Oracle SQL Plan Management: Stop a Good Plan From Going Bad

A query that ran in fifty milliseconds for a year is suddenly taking thirty seconds. Nobody changed the code. Nobody changed the query. And that's exactly the problem: the optimizer is allowed to chan

UAUptime Architectuptimearchitect.hashnode.devAug 17 · 16 min read

Oracle Optimizer Statistics, Demystified

The optimizer doesn't guess. It calculates — and every number in that calculation comes from statistics you either gathered on purpose or left to rot. That's the part the "the optimizer is dumb" stori

UAUptime Architectuptimearchitect.hashnode.devAug 12 · 16 min read

Oracle Execution Plans, Decoded: The One Number That Matters

EXPLAIN PLAN is a liar. Not on purpose — it just tells you what the optimizer hopes will happen, never what did. It's a forecast, printed with the confidence of a receipt. And a plan is nothing but fo

Uptime Architect

About

Available for

Uptime Architect's blogs

Recently published

Oracle Flashback: Undo at the Database Level

Oracle Transparent Data Encryption: Prove the Datafile Is Unreadable

Oracle SQL Plan Management: Stop a Good Plan From Going Bad

Oracle Optimizer Statistics, Demystified

Oracle Execution Plans, Decoded: The One Number That Matters

Search Hashnode

Uptime Architect

About

Available for

Uptime Architect's blogs

Recently published

Oracle Flashback: Undo at the Database Level

Oracle Transparent Data Encryption: Prove the Datafile Is Unreadable

Oracle SQL Plan Management: Stop a Good Plan From Going Bad

Oracle Optimizer Statistics, Demystified

Oracle Execution Plans, Decoded: The One Number That Matters