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

ORA-01652: Unable to Extend Temp Segment. Don't Just Add Space.

The open-orders report has run every morning for a year. Today it fails: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP The fix everyone knows is one line: add a tempfile. It take

1d ago · 14 min readuptimearchitect.hashnode.dev

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

The nightly batch used to finish in twenty minutes. Now it takes an hour, and during that hour the application stutters: every few seconds, every session that writes anything (an order, a login timest

4d ago · 13 min readuptimearchitect.hashnode.dev

Same SQL, Fast for One Value, Slow for Another

The order-history screen is fast for every customer except one. Or it's fast all morning and crawls all afternoon. Or it was fine for months and became slow the night after a restart, with nobody depl

Oct 21 · 15 min readuptimearchitect.hashnode.dev

Cutover Went Perfectly. The First New Order Failed With ORA-00001.

The migration went by the book. The initial load ran days ahead. On cutover night the final data refresh finished early, row counts matched table for table, the reconciliation report was green, and th

Oct 18 · 11 min readuptimearchitect.hashnode.dev

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

The audit table had grown to 200 million rows, so the team finally ran the purge: everything older than 90 days, gone. Ninety-nine percent of the rows deleted, committed, celebrated. The next morning

Oct 14 · 12 min readuptimearchitect.hashnode.dev

Uptime Architect

About

Available for

Uptime Architect's blogs

ORA-01652: Unable to Extend Temp Segment. Don't Just Add Space.

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

Same SQL, Fast for One Value, Slow for Another

Cutover Went Perfectly. The First New Order Failed With ORA-00001.

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

Search Hashnode

Uptime Architect

About

Available for

Uptime Architect's blogs

ORA-01652: Unable to Extend Temp Segment. Don't Just Add Space.

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

Same SQL, Fast for One Value, Slow for Another

Cutover Went Perfectly. The First New Order Failed With ORA-00001.

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.