Tanel Poder
@tanelpoder.com
Creator of https://0x.tools, also a long-time computer performance geek. Perf & troubleshooting blog: tanelpoder.com. All onions are mine.
Pinned
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql...
tanelpoder.com/posts/xb-sql...
Reposted by Tanel Poder
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
November 10, 2025 at 6:29 AM
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
Reposted by Tanel Poder
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
November 10, 2025 at 5:52 AM
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
November 10, 2025 at 6:29 AM
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
November 10, 2025 at 5:52 AM
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
Reposted by Tanel Poder
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
FreeSQL.com
November 6, 2025 at 10:42 PM
FreeSQL.com now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
Reposted by Tanel Poder
A bunch of folks at Oxide uncovered a tricky deadlock associated with async Rust (yes, another!), so--of course--@bcantrill.bsky.social and I got the crew together to discuss. If you're writing async Rust, you'll want to know how to avoid and diagnose "Futurelock"
Oxide and Friends 11/3/2025 -- Futurelock
YouTube video by Oxide Computer Company
www.youtube.com
November 6, 2025 at 3:20 PM
A bunch of folks at Oxide uncovered a tricky deadlock associated with async Rust (yes, another!), so--of course--@bcantrill.bsky.social and I got the crew together to discuss. If you're writing async Rust, you'll want to know how to avoid and diagnose "Futurelock"
Reposted by Tanel Poder
This post is awesome eavan.blog/posts/implem...
Please Implement This Simple SLO
eavan.blog
November 6, 2025 at 12:31 AM
This post is awesome eavan.blog/posts/implem...
Reposted by Tanel Poder
In concept I’m a huge fan of porting infrastructural code to Rust/memory safe languages, but shipping broken code — especially code that causes silent data loss — doesn’t help that cause.
`dd` incorrectly counts partial reads toward `count` limit, causing data loss in pipelines · Issue #9119 · uutils/coreutils
Summary uutils dd has a critical bug where partial reads from pipes are counted toward the count=N limit, causing premature termination and significant data loss. GNU dd correctly only counts full ...
github.com
November 5, 2025 at 11:28 PM
In concept I’m a huge fan of porting infrastructural code to Rust/memory safe languages, but shipping broken code — especially code that causes silent data loss — doesn’t help that cause.
Reposted by Tanel Poder
I just extended the Black Friday sale to the whole month of November!
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
November 2, 2025 at 9:45 PM
I just extended the Black Friday sale to the whole month of November!
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
Reposted by Tanel Poder
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql...
tanelpoder.com/posts/xb-sql...
November 3, 2025 at 7:48 AM
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql...
tanelpoder.com/posts/xb-sql...
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql...
tanelpoder.com/posts/xb-sql...
November 3, 2025 at 7:48 AM
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql...
tanelpoder.com/posts/xb-sql...
I just extended the Black Friday sale to the whole month of November!
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
November 2, 2025 at 9:45 PM
I just extended the Black Friday sale to the whole month of November!
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
All my existing full-week flagship courses are heavily discounted for the entire month, and more content coming soon!
tanelpoder.com/posts/black-...
Reposted by Tanel Poder
If you want to do *online* database schema migrations without degrading the performance of your system, the Expand and Contract Pattern is a great approach. And generally a great pattern to know about.
www.prisma.io/dataguide/ty...
www.prisma.io/dataguide/ty...
Using the expand and contract pattern | Prisma's Data Guide
In this article, we introduce the expand and contract pattern to help migrate data and clients to a new schema.
www.prisma.io
October 31, 2025 at 6:52 PM
If you want to do *online* database schema migrations without degrading the performance of your system, the Expand and Contract Pattern is a great approach. And generally a great pattern to know about.
www.prisma.io/dataguide/ty...
www.prisma.io/dataguide/ty...
Reposted by Tanel Poder
My colleague Dave Pacheco wrote up a great description of a new (to us?) Rust async pathology--"futurelock"--another extremely sharp edge to watch out for, with no particular guardrails. Of course, we'll be talking about it with @bcantrill.bsky.social on Monday's Oxide and Friends
609 - Futurelock / RFD / Oxide
rfd.shared.oxide.computer
October 31, 2025 at 7:00 PM
My colleague Dave Pacheco wrote up a great description of a new (to us?) Rust async pathology--"futurelock"--another extremely sharp edge to watch out for, with no particular guardrails. Of course, we'll be talking about it with @bcantrill.bsky.social on Monday's Oxide and Friends
Reposted by Tanel Poder
The first deep dive in my new special-focus training series starts on Wednesday:
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
October 31, 2025 at 4:44 AM
The first deep dive in my new special-focus training series starts on Wednesday:
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
Reposted by Tanel Poder
ladies and gentlemen...we got him
October 30, 2025 at 7:10 PM
ladies and gentlemen...we got him
The first deep dive in my new special-focus training series starts on Wednesday:
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
October 31, 2025 at 4:44 AM
The first deep dive in my new special-focus training series starts on Wednesday:
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).
One demo table has 100k partitions ;-)
Sign up here:
tanelpoder.com/seminar/
Reposted by Tanel Poder
The P99 CONF page is www.p99conf.io/session/xcap...
xCapture v3: Efficient, Always-On Thread Level Observability with eBPF
xCapture v3 offers deep Linux performance profiling with eBPF iterators and minimal CPU overhead.
www.p99conf.io
October 29, 2025 at 3:26 PM
The P99 CONF page is www.p99conf.io/session/xcap...
Reposted by Tanel Poder
The developer VM has been freshened up! Go get some!
www.oracle.com/database/tec...
www.oracle.com/database/tec...
October 28, 2025 at 11:43 PM
The developer VM has been freshened up! Go get some!
www.oracle.com/database/tec...
www.oracle.com/database/tec...
Reposted by Tanel Poder
AWS becoming the "millennial" cloud? A thing I'm sensing here and there:
Early-stage startups don't bother onboarding to a cloud service like AWS. They instead go for more "hip" startups for web hosting and databases. Think Vercel, Render, Railway, Supabase
They *might* move much later
Early-stage startups don't bother onboarding to a cloud service like AWS. They instead go for more "hip" startups for web hosting and databases. Think Vercel, Render, Railway, Supabase
They *might* move much later
October 29, 2025 at 11:37 AM
AWS becoming the "millennial" cloud? A thing I'm sensing here and there:
Early-stage startups don't bother onboarding to a cloud service like AWS. They instead go for more "hip" startups for web hosting and databases. Think Vercel, Render, Railway, Supabase
They *might* move much later
Early-stage startups don't bother onboarding to a cloud service like AWS. They instead go for more "hip" startups for web hosting and databases. Think Vercel, Render, Railway, Supabase
They *might* move much later
Reposted by Tanel Poder
... well, they might move later (to optimize infra costs), but they don't always do!
Cursor is an example of one where they moved to AWS for databases... got burnt and moved to Turbopuffer + Planetscale:
Are these one-offs or a trend?
newsletter.pragmaticengineer.com/p/cursor
Cursor is an example of one where they moved to AWS for databases... got burnt and moved to Turbopuffer + Planetscale:
Are these one-offs or a trend?
newsletter.pragmaticengineer.com/p/cursor
October 29, 2025 at 11:38 AM
... well, they might move later (to optimize infra costs), but they don't always do!
Cursor is an example of one where they moved to AWS for databases... got burnt and moved to Turbopuffer + Planetscale:
Are these one-offs or a trend?
newsletter.pragmaticengineer.com/p/cursor
Cursor is an example of one where they moved to AWS for databases... got burnt and moved to Turbopuffer + Planetscale:
Are these one-offs or a trend?
newsletter.pragmaticengineer.com/p/cursor
Reposted by Tanel Poder
meatcoding (it's like vibecoding but instead you use meat that can think)
October 24, 2025 at 9:42 PM
meatcoding (it's like vibecoding but instead you use meat that can think)
Reposted by Tanel Poder
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
QUALIFY: The WHERE Condition for Analytic Functions
Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…
danischnider.wordpress.com
October 24, 2025 at 2:35 PM
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
Previously on this show: Find which Oracle SQL_ID hits the SQL*Net break/reset to client event
tanelpoder.com/posts/find-w...
tanelpoder.com/posts/find-w...
October 24, 2025 at 1:30 PM
Previously on this show: Find which Oracle SQL_ID hits the SQL*Net break/reset to client event
tanelpoder.com/posts/find-w...
tanelpoder.com/posts/find-w...
Previously on this show: SQL Plan Execution FlameGraphs with Loop and Row Counts
tanelpoder.com/posts/sql-pl...
tanelpoder.com/posts/sql-pl...
October 24, 2025 at 1:27 PM
Previously on this show: SQL Plan Execution FlameGraphs with Loop and Row Counts
tanelpoder.com/posts/sql-pl...
tanelpoder.com/posts/sql-pl...