Releasing an eBPF Runtime Reporter and Profiler tool (brr). I've used it for profiling eBPF programs themselves. It unifies bpftop-like utilization/event frequency monitoring with perf_events based CPU sampling, with source code line mapping. github.com/tanelpoder/b...

Releasing an eBPF Runtime Reporter and Profiler tool (brr). I've used it for profiling eBPF programs themselves. It unifies bpftop-like utilization/event frequency monitoring with perf_events based CPU sampling, with source code line mapping. github.com/tanelpoder/b...

What I’m hearing: Instagram’s Trust and Safery org absolutely gutted the last few weeks. ~60% of the org gone - between layoffs and forced reassignments to data labelling. All while “AI maxxing” pushed a bunch of bugs to prod. And hence why today’s massive Instagram account takeover happening.

P99 Conf from @scylladb.com is looking for talks on eBPF 🐝 I've seen quite a few impressive talks there from the likes of Liz Rice, Tanel Poder, and Jose Fernandez. CfP is open until May 29th, let me know if you need help

P99 CONF 2026: Call for Speakers

Are you an engineer obsessed with P99 percentiles and high-performance, low-latency applications? Come share your most interesting approaches for solv...

sessionize.com

Almost Summer Sale 2026: All my flagship video courses discounted until end of May! Plus *free* Exadata Internals & Advanced Performance Metrics seminar videos! tanelpoder.com/posts/almost...

Almost Summer Sale 2026: All my flagship video courses discounted until end of May! Plus *free* Exadata Internals & Advanced Performance Metrics seminar videos! tanelpoder.com/posts/almost...

The LONG data type in Oracle Database is tricky to work with Sadly the partition high value column uses LONG 26ai eased this by adding CLOB and JSON versions of this But what if you're on older releases? @tanelpoder.com shows how to convert LONG to VARCHAR2 with PL/SQL

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier - Tanel Poder Blog

Here’s a little PL/SQL function create_partition_high_value_func.sql that allows you to write SQL queries against data dictionary for partition maintenance automation and examination operations, by…

buff.ly

A pretty recent summary article from Oracle on enabling and getting SQL monitoring reports in various ways (including historical captures): Real-Time SQL Monitoring: a MUST for SQL Tuning blogs.oracle.com/coretec/orac... (I'm working on something new & related too ;-)

A pretty recent summary article from Oracle on enabling and getting SQL monitoring reports in various ways (including historical captures): Real-Time SQL Monitoring: a MUST for SQL Tuning blogs.oracle.com/coretec/orac... (I'm working on something new & related too ;-)

🚨 periodic reminder for macOS computer havers: System Settings > General > Login Items & Extensions 1. Go through the entire list 2. Remove stuff + Toggle stuff off (or on) 3. Breathe a bit easier Tahoe: support.apple.com/guide/mac-he... Sequoia: support.apple.com/guide/mac-he...

I've been busy in the last months! Announcing a brand new "Practical Exadata Performance" training course! I'm not aware of any other training *like this* offered in the world. 😎 Also, a *free* seminar! Exadata is an awesome platform, if used right! learn.tanelpoder.com

Fresh vid! The new SQL History feature in Oracle Database 26ai lets you track every single execution in your session. So why is it empty all of a sudden? youtu.be/XKN-SjrpzLc

Why has my SQL history gone MISSING?

YouTube video by SQL and Database explained!

youtu.be

I've been busy in the last months! Announcing a brand new "Practical Exadata Performance" training course! I'm not aware of any other training *like this* offered in the world. 😎 Also, a *free* seminar! Exadata is an awesome platform, if used right! learn.tanelpoder.com

Was doing some Exadata performance work and this question came up: "Where does the Exadata storage() predicate come from?" I wrote about it a while ago 😎 tanelpoder.com/2014/03/05/w... The inmemory() predicate works using similar logic: access_predicate on INMEMORY full table scan.

Was doing some Exadata performance work and this question came up: "Where does the Exadata storage() predicate come from?" I wrote about it a while ago 😎 tanelpoder.com/2014/03/05/w... The inmemory() predicate works using similar logic: access_predicate on INMEMORY full table scan.

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier (new blog). There's also some data 23/26ai data dictionary internals! tanelpoder.com/posts/oracle...

Blog greatest hits :-) . The death of the demo script. https://connor-mcdonald.com/2016/03/23/the-death-of-the-demo-script

Imagine your team doing agentic coding in the codebase serving mills of customers without understanding how it works, and you get paged at 2 am, and since no one knows how the system works you need to ask LLM to tell you, and it gives you, wait for it... a PLAUSIBLE answer what might be wrong.

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier (new blog). There's also some data 23/26ai data dictionary internals! tanelpoder.com/posts/oracle...

Jan Nidzwetzki - pg_plan_alternatives: Tracing PostgreSQL's Query Plan Alternatives using eBPF jnidzwetzki.github.io/2026/03/04/p...

My observation is that AI has sped up development of mainline, never before seen features at the median shop by ~1.2x. Undifferentiated backlog items move much faster, so does any new product line with no customers or load bearing infrastructure yet. Bottleneck is verification and review

Another old but interesting blog post (2008!) An Oracle database may have duplicate (non-unique) ROWIDs (and data object IDs) when using transportable tablespaces. That's not a bug, Oracle guarantees ROWID uniqueness only at table level, not at DB level. tanelpoder.com/2008/10/21/t...

Another old but interesting blog post (2008!) An Oracle database may have duplicate (non-unique) ROWIDs (and data object IDs) when using transportable tablespaces. That's not a bug, Oracle guarantees ROWID uniqueness only at table level, not at DB level. tanelpoder.com/2008/10/21/t...

Oxide and Friends is back, at a special time! @ahl.bsky.social and I will be joined by Oxide engineers Andrew Stone and Finch Foner to talk about how we build a quorum of trust in the distributed system that is the Oxide rack. Join us today at 2p Pacific/5p Eastern! discord.gg/QrcKGTTPrF?e...

Old but gold (2024): Oracle Hint Scopes and Join Level Cardinality Hint: tanelpoder.com/posts/oracle...

Old but gold (2024): Oracle Hint Scopes and Join Level Cardinality Hint: tanelpoder.com/posts/oracle...

If you use GitHub (especially if you pay for it!!) consider doing this *immediately* Settings -> Privacy -> Disallow GitHub to train their models on your code. GitHub opted *everyone* into training. No matter if you pay for the service (like I do). WTH github.com/settings/cop...

And just like that, it's time for March's Interesting Links in the Data and AI World! 👉🏻 rmoff.net/2026/03/25/i... With links from great folk including @gunnarmorling.dev, @tomcooper.dev, @sqlliz.bsky.social, @tanelpoder.com, @eatonphil.bsky.social, @larahogan.bsky.social, @almog.xyz, and more!

Interesting links - March 2026

rmoff.net

Old but gold! (2025) Find which Oracle SQL_ID hits the SQL*Net break/reset to client event: tanelpoder.com/posts/find-w...

Old but gold! (2025) Find which Oracle SQL_ID hits the SQL*Net break/reset to client event: tanelpoder.com/posts/find-w...