@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.dev29 posts

Articles Comments

Recently published

UAUptime Architectuptimearchitect.hashnode.dev2d ago · 14 min read

The Migration Completed Successfully. Half the Names Are Now Question Marks.

The cutover ran clean. impdp reported completed successfully, the row counts matched to the row, the application came up, and everyone went home. Three weeks later a support ticket lands: a customer n

UAUptime Architectuptimearchitect.hashnode.dev5d ago · 12 min read

Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.

The database is patched. The data files are encrypted with TDE. The audit trail is clean. And every query your application runs — along with every row it gets back — crosses the network as readable te

UAUptime Architectuptimearchitect.hashnode.dev6d ago · 15 min read

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

The pager goes off at 3 a.m.: the application is frozen. Every screen that tries to save hangs, and the ones that time out come back with ORA-00257: archiver error. Connect internal only, until freed.

UAUptime Architectuptimearchitect.hashnode.devOct 1 · 13 min read

ORA-01555 Snapshot Too Old: Reproduce It, Then Make It Impossible

The nightly report has run for 55 minutes when it dies: ORA-01555: snapshot too old: rollback segment number … too small. You didn't change the query. The data is fine. Run it again at 2 a.m. and it w

UAUptime Architectuptimearchitect.hashnode.devSep 27 · 14 min read

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool

The database is pinned at 90% CPU, the app team swears nothing changed, and AWR is topped by cursor: pin S wait on X and a parse-heavy profile. Nobody wrote a slow query. What happened is quieter: som

Uptime Architect

About

Available for

Uptime Architect's blogs

Recently published

The Migration Completed Successfully. Half the Names Are Now Question Marks.

Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

ORA-01555 Snapshot Too Old: Reproduce It, Then Make It Impossible

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool

Search Hashnode

Uptime Architect

About

Available for

Uptime Architect's blogs

Recently published

The Migration Completed Successfully. Half the Names Are Now Question Marks.

Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

ORA-01555 Snapshot Too Old: Reproduce It, Then Make It Impossible

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool