corpus.blog
56,966 blogs · [ { "id": "01a087e9-67f6-72df-86c6-289968468450", "title": "Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier", "url": "https://tanelpoder.com/posts/oracle-get-partition-high-value-function/", "published_at": "2026-04-10T17:00:30+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996933386a", "title": "Testing the Datadog Explain Plan Visualizer with Oracle execution plans", "url": "https://tanelpoder.com/posts/testing-datadog-plan-visualizer-with-oracle-execution-plans/", "published_at": "2026-03-01T01:37:33+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996982c942", "title": "New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity", "url": "https://tanelpoder.com/posts/oracle-vstat-dstat-metric-history-scripts/", "published_at": "2025-11-10T02:53:07+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289969cb3cf1", "title": "xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)", "url": "https://tanelpoder.com/posts/xb-sql-script-explain-oracle-plan-better-part-3/", "published_at": "2025-11-03T06:00:29+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996aac6d50", "title": "tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates", "url": "https://tanelpoder.com/posts/tabhisthybrid-script/", "published_at": "2025-10-20T06:05:56+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996b7b73fe", "title": "pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL", "url": "https://tanelpoder.com/posts/generate-qr-code-with-pure-sql-in-postgres/", "published_at": "2025-10-12T00:31:31+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996c591f9b", "title": "The xCapture and xtop eBPF tools are now in beta, with a demo dataset", "url": "https://tanelpoder.com/posts/xcapture-xtop-beta/", "published_at": "2025-09-09T16:18:32+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996cd3e4dd", "title": "CatVector Demo Website", "url": "https://tanelpoder.com/posts/catvector-static/", "published_at": "2025-08-24T23:50:26+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996d133ada", "title": "New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without Any Tracepoints", "url": "https://tanelpoder.com/posts/xstack-passive-linux-stack-sampler-ebpf/", "published_at": "2025-08-14T21:01:35+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996d414495", "title": "Dimensional Analysis of System Performance with eBPF & xtop: Top for Wall-Clock Time", "url": "https://tanelpoder.com/posts/xtop-top-for-wall-clock-time/", "published_at": "2025-08-13T03:46:44+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996e2c6f47", "title": "Webinar: Testing High-Performance Vector Search With CatBench on Google AlloyDB Omni", "url": "https://tanelpoder.com/posts/testing-vector-search-with-google-alloydb-omni-and-catbench/", "published_at": "2025-07-02T08:32:01+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996ea48a4f", "title": "My Blog Has Turned 18 Years Old", "url": "https://tanelpoder.com/posts/my-blog-has-turned-18-years-old/", "published_at": "2025-06-18T18:14:49+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28996fa46198", "title": "Catbench Vector Search App has Postgres Query Throughput and Latency Monitoring Now", "url": "https://tanelpoder.com/posts/catbench-vector-search-query-throughput-latency-monitoring/", "published_at": "2025-05-30T18:18:01+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289970784ae7", "title": "Using Postgres pg_test_fsync tool for testing low latency writes", "url": "https://tanelpoder.com/posts/using-pg-test-fsync-for-testing-low-latency-writes/", "published_at": "2025-05-28T00:31:34+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899708932fc", "title": "Find which Oracle SQL_ID hits the SQL*Net break/reset to client event", "url": "https://tanelpoder.com/posts/find-which-oracle-sql-id-hit-sqlnet-break-reset-event/", "published_at": "2025-05-14T14:00:08+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997137c6c4", "title": "New Tool: lsds - List All Linux Block Devices and Settings in One Place", "url": "https://tanelpoder.com/posts/lsds-list-linux-block-devices-and-their-config/", "published_at": "2025-05-09T14:23:21+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899716bdf67", "title": "Optimizing eBPF I/O latency accounting when running 37M IOPS on a 384-CPU server", "url": "https://tanelpoder.com/posts/optimizing-ebpf-biolatency-accounting/", "published_at": "2025-04-30T01:42:03+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899716d5993", "title": "xCapture v3: Linux Performance Analysis with Modern eBPF and DuckDB", "url": "https://tanelpoder.com/posts/xcapture-v3-alpha-ebpf-performance-analysis-with-duckdb/", "published_at": "2025-04-23T20:04:06+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997239d0b3", "title": "When eBPF task->stack->pt_regs reads return garbage on the latest Linux kernels, blame Fred!", "url": "https://tanelpoder.com/posts/ebpf-pt-regs-error-on-linux-blame-fred/", "published_at": "2025-03-01T00:57:27+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289972f6f105", "title": "TracepointArgs: List Any Linux Tracepoint with Their Arguments, Datatypes and Related Structs", "url": "https://tanelpoder.com/posts/tpargs-list-tracepoint-arguments-and-structures/", "published_at": "2025-01-30T13:13:29+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289973ce692e", "title": "CatBench Vector Search Playground", "url": "https://tanelpoder.com/posts/catbench-vector-search-playground/", "published_at": "2025-01-26T20:49:58+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289974b53557", "title": "Embedding Vectors of the Same Image Rotated Over 360 Degrees", "url": "https://tanelpoder.com/posts/comparing-vectors-of-the-same-rotated-image/", "published_at": "2025-01-13T03:34:14+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289975917ba1", "title": "SQL Plan Execution FlameGraphs with Loop and Row Counts", "url": "https://tanelpoder.com/posts/sql-plan-flamegraph-loop-row-counts/", "published_at": "2025-01-04T04:12:10+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289975a7206f", "title": "Embedding Vectors vs. Vector Embeddings", "url": "https://tanelpoder.com/posts/embedding-vectors-vs-vector-embeddings/", "published_at": "2024-12-08T01:38:11+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997648f78d", "title": "Video: Testing the Silk Platform in 2024 Interview (12 minutes)", "url": "https://tanelpoder.com/posts/testing-the-silk-platform-in-2024-interview/", "published_at": "2024-11-28T19:52:59+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899766f980f", "title": "Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VM", "url": "https://tanelpoder.com/posts/testing-the-silk-platform-in-2024/", "published_at": "2024-11-06T00:32:23+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289976ad35c7", "title": "Visualizing and Comparing Embedding Vectors as Heatmaps (Videos)", "url": "https://tanelpoder.com/posts/visualizing-embedding-vectors-as-heatmaps-videos/", "published_at": "2024-09-23T13:32:27+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289976b31d91", "title": "Visualizing and Comparing Embedding Vectors as Heatmaps", "url": "https://tanelpoder.com/posts/visualizing-embedding-vectors-as-heatmaps/", "published_at": "2024-09-21T01:16:34+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289977349151", "title": "Tracking, not Tracing, Linux Thread Activity for Complete System Visibility (eBPF Summit)", "url": "https://tanelpoder.com/posts/tracking-not-tracing-linux-thread-activity-with-ebpf/", "published_at": "2024-09-13T00:55:07+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997810bc79", "title": "Python Supports Profiling with Perf - How Does It Work?", "url": "https://tanelpoder.com/posts/python-perf-profiling-support/", "published_at": "2024-07-31T05:14:56+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289978ca89ac", "title": "Can a User Process Consume Kernel Mode CPU Without a Syscall?", "url": "https://tanelpoder.com/posts/user-process-consuming-kernel-cpu-without-a-syscall/", "published_at": "2024-07-10T13:33:13+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289978e63ea3", "title": "Next Big Thing: X-Ray Vision for Linux Systems with eBPF", "url": "https://tanelpoder.com/posts/next-big-thing/", "published_at": "2024-06-22T00:14:02+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899790c8983", "title": "Syscallargs: List All Linux System Calls With Their Arguments", "url": "https://tanelpoder.com/posts/list-linux-system-call-arguments-with-syscallargs/", "published_at": "2024-06-14T03:50:24+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899797bac52", "title": "RTX4090 converted into an eGPU", "url": "https://tanelpoder.com/posts/rtx4090-egpu/", "published_at": "2024-06-07T10:59:31+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997a28ec10", "title": "Oracle Hint Scopes and Join Level Cardinality Hint", "url": "https://tanelpoder.com/posts/oracle-hint-scopes-and-join-level-cardinality/", "published_at": "2024-06-07T02:16:36+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997ad9e40c", "title": "New Commenting System", "url": "https://tanelpoder.com/posts/new-commenting-system/", "published_at": "2024-06-05T20:49:45+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997b40bcc0", "title": "Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps", "url": "https://tanelpoder.com/posts/oracle-shared-pool-chunk-status-indicators-in-heapdump/", "published_at": "2024-03-08T17:56:46+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997b7ac295", "title": "Oracle Index Parallel Degree Fix After Parallel Creation or Rebuild", "url": "https://tanelpoder.com/posts/index-parallelism-fix/", "published_at": "2024-02-13T03:55:14+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997c713aab", "title": "Report Current Oracle Session Wait Chains from GV$SESSION without ASH", "url": "https://tanelpoder.com/posts/oracle-session-wait-chains-swc/", "published_at": "2022-09-24T22:08:14+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997d5feaeb", "title": "Advanced Oracle Troubleshooting Guide, Part 13: OStackProf for Linux, Unix & MacOSX Clients", "url": "https://tanelpoder.com/posts/advanced-oracle-troubleshooting-guide-part-13-ostackprof-for-linux-macosx-clients/", "published_at": "2022-09-17T04:41:48+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997e4615fd", "title": "Testing Oracle's Use of Optane Persistent Memory, Part 2 - Fast Log File Sync Waits", "url": "https://tanelpoder.com/posts/testing-oracles-use-of-optane-persistent-memory-log-file-sync/", "published_at": "2022-07-15T05:10:23+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997e6120e0", "title": "Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits", "url": "https://tanelpoder.com/posts/testing-oracles-use-of-optane-persistent-memory/", "published_at": "2022-04-28T04:54:38+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997f51f6d5", "title": "MySQL Now Shows its Thread Names at OS Level for Better Troubleshooting", "url": "https://tanelpoder.com/posts/mysql-now-shows-thread-names-at-os-level/", "published_at": "2022-03-17T18:19:40+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28997fdaa8a9", "title": "xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2)", "url": "https://tanelpoder.com/posts/xb-sql-script-explain-oracle-plan-better-part-2/", "published_at": "2022-03-17T05:25:20+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289980198a19", "title": "My New Learning Platform and What I'm Up To in 2022", "url": "https://tanelpoder.com/posts/new-training-format-2022/", "published_at": "2022-03-15T02:12:31+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998071c3b2", "title": "Achieving 10 GB/s Scanning Rate in a Single Cloud VM", "url": "https://tanelpoder.com/posts/achieving-over-10gbytes-scanning-rate-in-the-cloud/", "published_at": "2021-11-18T17:52:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289981424704", "title": "Testing The Silk Platform - Hands-On Technical Analysis of High-Performance I/O in the Cloud", "url": "https://tanelpoder.com/posts/testing-the-silk-platform/", "published_at": "2021-10-18T10:30:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899821a3ca4", "title": "Do Not Use '>' in Your Command Prompt (and How to Stay Safe in Shell)", "url": "https://tanelpoder.com/posts/how-to-stay-safe-in-shell/", "published_at": "2021-03-16T21:30:29+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289982ca7fd8", "title": "Video: Troubleshooting Complex Oracle Issues Part 2", "url": "https://tanelpoder.com/videos/troubleshooting-complex-oracle-issues-part-2/", "published_at": "2021-03-03T22:44:54+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289983351f9a", "title": "Is Your Linux Version Hiding Interrupt CPU Usage From You?", "url": "https://tanelpoder.com/posts/linux-hiding-interrupt-cpu-usage/", "published_at": "2021-02-15T05:00:35+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899833d82fb", "title": "Video: High Performance Block I/O on Linux", "url": "https://tanelpoder.com/posts/high-performance-block-io-on-linux/", "published_at": "2021-02-07T20:58:57+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998428403f", "title": "Achieving 11M IOPS & 66 GiB/s IO on a Single ThreadRipper Workstation", "url": "https://tanelpoder.com/posts/11m-iops-with-10-ssds-on-amd-threadripper-pro-workstation/", "published_at": "2021-01-29T12:40:33+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998500da4c", "title": "Oracle Wait Event Name vs. Display Name", "url": "https://tanelpoder.com/posts/oracle-wait-event-name-display-name/", "published_at": "2021-01-13T03:03:08+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289985a0acff", "title": "Measuring Java JVM thread activity in Linux with task state sampling", "url": "https://tanelpoder.com/posts/measuring-java-jvm-thread-level-activity-on-linux/", "published_at": "2020-11-28T22:52:09+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998692d2d4", "title": "Reasons why SELECT * is bad for SQL performance", "url": "https://tanelpoder.com/posts/reasons-why-select-star-is-bad-for-sql-performance/", "published_at": "2020-11-25T03:14:58+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899871c7b49", "title": "High System Load with Low CPU Utilization on Linux?", "url": "https://tanelpoder.com/posts/high-system-load-low-cpu-utilization-on-linux/", "published_at": "2020-11-20T16:31:58+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289988064a96", "title": "Hacking Session: 7 Levels of Hint Invalidity in Oracle SQL", "url": "https://tanelpoder.com/posts/hacking-session-7-levels-of-oracle-sql-hint-invalidity/", "published_at": "2020-05-21T16:00:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289988d155be", "title": "Hacking Session: Oracle SQL Monitoring - Understanding the Execution Timeline column and CPU usage", "url": "https://tanelpoder.com/posts/hacking-session-oracle-sql-monitoring-timeline-column-and-cpu-usage/", "published_at": "2020-05-08T21:00:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289988fd37c6", "title": "Oracle Fatal Background Processes", "url": "https://tanelpoder.com/posts/oracle-fatal-background-processes/", "published_at": "2020-03-24T07:11:16+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289989dd7c94", "title": "Oracle Shared Pool Internals: List Chunk Position in the LRU List", "url": "https://tanelpoder.com/posts/oracle-shared-pool-list-chunk-position-in-lru-list/", "published_at": "2020-03-04T06:11:29+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998ad68650", "title": "SchedLat: a Low Tech Script for Measuring Process CPU Scheduling Latency on Linux", "url": "https://tanelpoder.com/posts/schedlat-low-tech-script-for-measuring-cpu-scheduling-latency-on-linux/", "published_at": "2020-02-27T04:18:52+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998add2c32", "title": "Announcing My Retirement (in 2030)!", "url": "https://tanelpoder.com/posts/announcing-my-retirement-in-2030/", "published_at": "2020-02-19T07:33:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998bad0418", "title": "ORA-12850: Could not allocate slaves on all specified instances error and a workaround for my scripts", "url": "https://tanelpoder.com/posts/ora-12850-could-not-allocate-slaves-on-all-specified-instancs-error/", "published_at": "2020-02-12T05:04:11+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998bc6ba17", "title": "Oracle Performance Troubleshooting Without OS Access, Part 1: Identifying CPU Scheduling Latency", "url": "https://tanelpoder.com/posts/oracle-performance-troubleshooting-without-os-access-part-1/", "published_at": "2020-02-11T03:27:51+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998cbcc91c", "title": "Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020)", "url": "https://tanelpoder.com/posts/troubleshooting-complex-oracle-performance-problems-jan-2020-video/", "published_at": "2020-02-03T03:52:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998d54b97c", "title": "Hacking Session: Troubleshooting Complex Oracle Performance Problems (January 2020)", "url": "https://tanelpoder.com/posts/hacking-session-troubleshooting-complex-oracle-performance-problems/", "published_at": "2020-01-30T04:00:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998e0afb53", "title": "help.sql: Show TPT Script Purpose and Syntax", "url": "https://tanelpoder.com/posts/help-sql-show-tpt-script-purpose-and-syntax/", "published_at": "2020-01-15T17:07:33+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998e8fdd2f", "title": "Oracle State Objects and Reading System State Dumps Hacking Session Video", "url": "https://tanelpoder.com/posts/oracle-state-objects-system-state-dumps-hacking-session-video/", "published_at": "2020-01-09T05:47:23+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998f15d668", "title": "New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1)", "url": "https://tanelpoder.com/posts/xb-sql-script-explain-oracle-plan-better-part-1/", "published_at": "2019-10-04T15:25:20+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998f19319e", "title": "Dump Current Oracle SQL Execution Plan Line ID Using Oradebug", "url": "https://tanelpoder.com/posts/oracle-dump-current-execution-plan-line-using-oradebug/", "published_at": "2019-04-08T15:03:43+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28998fa3463f", "title": "pSnapper: Linux Process Snapper Page and Videos", "url": "https://tanelpoder.com/posts/linux-process-snapper-videos/", "published_at": "2019-04-03T20:03:59+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289990117de2", "title": "Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT)", "url": "https://tanelpoder.com/posts/linux-troubleshooting-hacking-session/", "published_at": "2019-04-01T03:53:28+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289990ba983b", "title": "What Caused This Wait Event: Using Oracle's wait_event[] tracing", "url": "https://tanelpoder.com/posts/what-caused-this-wait-event/", "published_at": "2019-03-29T15:30:04+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289990e11fbb", "title": "Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds?", "url": "https://tanelpoder.com/posts/troubleshooting-linux-ssh-logon-delay-always-takes-10-seconds/", "published_at": "2019-03-07T17:16:58+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899914cf3a0", "title": "Practical Linux Performance & Application Troubleshooting Training Details and Table of Contents", "url": "https://tanelpoder.com/posts/practical-linux-application-and-performance-troubleshooting-training-details-and-toc/", "published_at": "2019-03-04T20:16:07+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289991c04d89", "title": "Scripts for Drilling Down Into Unknown Optimizer Changes", "url": "https://tanelpoder.com/posts/scripts-for-drilling-down-into-unknown-optimizer-changes/", "published_at": "2018-11-09T03:47:32+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289992bb3fad", "title": "Visualizing SQL Plan Execution Time With FlameGraphs", "url": "https://tanelpoder.com/posts/visualizing-sql-plan-execution-time-with-flamegraphs/", "published_at": "2018-10-28T05:26:02+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289992c96730", "title": "Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed)", "url": "https://tanelpoder.com/posts/oracle-sql-monitoring-html-reports-using-sql-developer-v183/", "published_at": "2018-10-10T21:00:52+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289993522d95", "title": "Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progress", "url": "https://tanelpoder.com/posts/log-file-switch-checkpoint-incomplete-and-lgwr-waiting-for-checkpoint-progress/", "published_at": "2018-10-08T04:00:08+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289993adc710", "title": "Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!", "url": "https://tanelpoder.com/posts/oracle-sql-monitoring-advanced-ash-usage-hacking-session/", "published_at": "2018-08-29T18:25:38+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289993b248d1", "title": "Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!", "url": "https://tanelpoder.com/posts/2018-08-20-oracle-sql-tuning-training-oracle-troubleshooting-training/", "published_at": "2018-08-21T01:53:00+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899947d139c", "title": "Webinar: Troubleshooting a Complex Oracle Performance Issue", "url": "https://tanelpoder.com/posts/2018-06-07-troubleshooting-a-complex-oracle-performance-issue/", "published_at": "2018-06-07T06:26:57+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289995298e04", "title": "My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced", "url": "https://tanelpoder.com/2018/05/18/my-performance-troubleshooting-scripts-tpt-for-oracle-are-now-in-github-and-open-sourced/", "published_at": "2018-05-18T20:13:22+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289996202e6f", "title": "Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication", "url": "https://tanelpoder.com/2018/01/24/3794/", "published_at": "2018-01-25T03:33:54+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289996a5e591", "title": "Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too", "url": "https://tanelpoder.com/2018/01/11/secret-hacking-session-oracle-background-process-communication-exotic-wait-events-and-some-tracing-too/", "published_at": "2018-01-11T20:34:51+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289996cb025f", "title": "Advanced Oracle Troubleshooting seminar in 2018!", "url": "https://tanelpoder.com/2017/11/29/advanced-oracle-troubleshooting-seminar-in-2018/", "published_at": "2017-11-29T22:24:06+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289997b0c1e1", "title": "Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month", "url": "https://tanelpoder.com/2017/07/11/apache-impala-internals-deep-dive-with-tanel-poder-gluent-new-world-training-month/", "published_at": "2017-07-11T16:51:21+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899983c1993", "title": "GNW01: In-Memory Processing for Databases", "url": "https://tanelpoder.com/2016/03/27/gnw01-in-memory-processing-for-databases/", "published_at": "2016-03-28T05:39:25+00:00" }, { "id": "01a087e9-67f6-72df-86c6-2899990f9ff8", "title": "My BIWA Summit Presentations", "url": "https://tanelpoder.com/2016/01/26/my-biwa-summit-presentations/", "published_at": "2016-01-26T23:01:45+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289999962e9e", "title": "RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cycles", "url": "https://tanelpoder.com/2015/11/30/ram-is-the-new-disk-and-how-to-measure-its-performance-part-3-cpu-instructions-cycles/", "published_at": "2015-11-30T06:45:58+00:00" }, { "id": "01a087e9-67f6-72df-86c6-289999c66d8a", "title": "My New Youtube Channel", "url": "https://tanelpoder.com/2015/11/23/my-new-youtube-channel/", "published_at": "2015-11-24T04:30:28+00:00" }, { "id": "01a087e9-67f6-72df-86c6-28999a6c859e", "title": "Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention", "url": "https://tanelpoder.com/2015/11/10/troubleshooting-another-complex-performance-issue-oracle-direct-path-inserts-and-seg-contention/", "published_at": "2015-11-11T00:35:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2b9b1244", "title": "SQL Monitoring in Oracle Database 12c", "url": "https://tanelpoder.com/2015/10/29/sql-monitoring-in-oracle-database-12c/", "published_at": "2015-10-29T18:53:08+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2c0b4628", "title": "Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)", "url": "https://tanelpoder.com/2015/10/09/advanced-oracle-troubleshooting-v2-5-with-12c-stuff-too/", "published_at": "2015-10-09T07:58:08+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2cfed232", "title": "RAM is the new disk – and how to measure its performance – Part 2 – Tools", "url": "https://tanelpoder.com/2015/09/21/ram-is-the-new-disk-and-how-to-measure-its-performance-part-2-tools/", "published_at": "2015-09-21T08:20:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2d0a37dd", "title": "RAM is the new disk – and how to measure its performance – Part 1 – Introduction", "url": "https://tanelpoder.com/2015/08/09/ram-is-the-new-disk-and-how-to-measure-its-performance-part-1/", "published_at": "2015-08-09T23:26:55+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2d6cebfe", "title": "The Hybrid World is Coming", "url": "https://tanelpoder.com/2015/06/29/the-hybrid-world-is-coming/", "published_at": "2015-06-29T23:14:13+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2d90a8ac", "title": "Old ventures and new adventures", "url": "https://tanelpoder.com/2015/06/19/old-ventures-and-new-adventures/", "published_at": "2015-06-19T06:08:33+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2da1b0d5", "title": "Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits?", "url": "https://tanelpoder.com/2015/04/24/advanced-oracle-troubleshooting-guide-part-12-control-file-parallel-reads-causing-enq-sq-contention-waits/", "published_at": "2015-04-24T23:23:32+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2e367c8a", "title": "Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable", "url": "https://tanelpoder.com/2015/03/29/sqlplus-is-my-second-home-part-8-embedding-multiple-sqlplus-arguments-into-one-variable/", "published_at": "2015-03-29T21:23:51+00:00" } ] posts Claim your blog
Back to tanelpoder
Blog · corpus.blog/blogs/tanelpoder.com/posts

tanelpoder

tanelpoder.com

2026

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlieroriginal ↗
10 Apr 2026
Testing the Datadog Explain Plan Visualizer with Oracle execution plansoriginal ↗
1 Mar 2026

2025

New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularityoriginal ↗
10 Nov 2025
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)original ↗
3 Nov 2025
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimatesoriginal ↗
20 Oct 2025
pqr.sql: Generate QR Codes with Pure SQL in PostgreSQLoriginal ↗
12 Oct 2025
The xCapture and xtop eBPF tools are now in beta, with a demo datasetoriginal ↗
9 Sept 2025
CatVector Demo Websiteoriginal ↗
24 Aug 2025
New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without Any Tracepointsoriginal ↗
14 Aug 2025
Dimensional Analysis of System Performance with eBPF & xtop: Top for Wall-Clock Timeoriginal ↗
13 Aug 2025
Webinar: Testing High-Performance Vector Search With CatBench on Google AlloyDB Omnioriginal ↗
2 Jul 2025
My Blog Has Turned 18 Years Oldoriginal ↗
18 Jun 2025
Catbench Vector Search App has Postgres Query Throughput and Latency Monitoring Noworiginal ↗
30 May 2025
Using Postgres pg_test_fsync tool for testing low latency writesoriginal ↗
28 May 2025
Find which Oracle SQL_ID hits the SQL*Net break/reset to client eventoriginal ↗
14 May 2025
New Tool: lsds - List All Linux Block Devices and Settings in One Placeoriginal ↗
9 May 2025
Optimizing eBPF I/O latency accounting when running 37M IOPS on a 384-CPU serveroriginal ↗
30 Apr 2025
xCapture v3: Linux Performance Analysis with Modern eBPF and DuckDBoriginal ↗
23 Apr 2025
When eBPF task->stack->pt_regs reads return garbage on the latest Linux kernels, blame Fred!original ↗
1 Mar 2025
TracepointArgs: List Any Linux Tracepoint with Their Arguments, Datatypes and Related Structsoriginal ↗
30 Jan 2025
CatBench Vector Search Playgroundoriginal ↗
26 Jan 2025
Embedding Vectors of the Same Image Rotated Over 360 Degreesoriginal ↗
13 Jan 2025
SQL Plan Execution FlameGraphs with Loop and Row Countsoriginal ↗
4 Jan 2025

2024

Embedding Vectors vs. Vector Embeddingsoriginal ↗
8 Dec 2024
Video: Testing the Silk Platform in 2024 Interview (12 minutes)original ↗
28 Nov 2024
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VMoriginal ↗
6 Nov 2024
Visualizing and Comparing Embedding Vectors as Heatmaps (Videos)original ↗
23 Sept 2024
Visualizing and Comparing Embedding Vectors as Heatmapsoriginal ↗
21 Sept 2024
Tracking, not Tracing, Linux Thread Activity for Complete System Visibility (eBPF Summit)original ↗
13 Sept 2024
Python Supports Profiling with Perf - How Does It Work?original ↗
31 Jul 2024
Can a User Process Consume Kernel Mode CPU Without a Syscall?original ↗
10 Jul 2024
Next Big Thing: X-Ray Vision for Linux Systems with eBPForiginal ↗
22 Jun 2024
Syscallargs: List All Linux System Calls With Their Argumentsoriginal ↗
14 Jun 2024
RTX4090 converted into an eGPUoriginal ↗
7 Jun 2024
Oracle Hint Scopes and Join Level Cardinality Hintoriginal ↗
7 Jun 2024
New Commenting Systemoriginal ↗
5 Jun 2024
Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumpsoriginal ↗
8 Mar 2024
Oracle Index Parallel Degree Fix After Parallel Creation or Rebuildoriginal ↗
13 Feb 2024

2022

Report Current Oracle Session Wait Chains from GV$SESSION without ASHoriginal ↗
24 Sept 2022
Advanced Oracle Troubleshooting Guide, Part 13: OStackProf for Linux, Unix & MacOSX Clientsoriginal ↗
17 Sept 2022
Testing Oracle's Use of Optane Persistent Memory, Part 2 - Fast Log File Sync Waitsoriginal ↗
15 Jul 2022
Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commitsoriginal ↗
28 Apr 2022
MySQL Now Shows its Thread Names at OS Level for Better Troubleshootingoriginal ↗
17 Mar 2022
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2)original ↗
17 Mar 2022
My New Learning Platform and What I'm Up To in 2022original ↗
15 Mar 2022

2021

Achieving 10 GB/s Scanning Rate in a Single Cloud VMoriginal ↗
18 Nov 2021
Testing The Silk Platform - Hands-On Technical Analysis of High-Performance I/O in the Cloudoriginal ↗
18 Oct 2021
Do Not Use '>' in Your Command Prompt (and How to Stay Safe in Shell)original ↗
16 Mar 2021
Video: Troubleshooting Complex Oracle Issues Part 2original ↗
3 Mar 2021
Is Your Linux Version Hiding Interrupt CPU Usage From You?original ↗
15 Feb 2021
Video: High Performance Block I/O on Linuxoriginal ↗
7 Feb 2021
Achieving 11M IOPS & 66 GiB/s IO on a Single ThreadRipper Workstationoriginal ↗
29 Jan 2021
Oracle Wait Event Name vs. Display Nameoriginal ↗
13 Jan 2021

2020

Measuring Java JVM thread activity in Linux with task state samplingoriginal ↗
28 Nov 2020
Reasons why SELECT * is bad for SQL performanceoriginal ↗
25 Nov 2020
High System Load with Low CPU Utilization on Linux?original ↗
20 Nov 2020
Hacking Session: 7 Levels of Hint Invalidity in Oracle SQLoriginal ↗
21 May 2020
Hacking Session: Oracle SQL Monitoring - Understanding the Execution Timeline column and CPU usageoriginal ↗
8 May 2020
Oracle Fatal Background Processesoriginal ↗
24 Mar 2020
Oracle Shared Pool Internals: List Chunk Position in the LRU Listoriginal ↗
4 Mar 2020
SchedLat: a Low Tech Script for Measuring Process CPU Scheduling Latency on Linuxoriginal ↗
27 Feb 2020
Announcing My Retirement (in 2030)!original ↗
19 Feb 2020
ORA-12850: Could not allocate slaves on all specified instances error and a workaround for my scriptsoriginal ↗
12 Feb 2020
Oracle Performance Troubleshooting Without OS Access, Part 1: Identifying CPU Scheduling Latencyoriginal ↗
11 Feb 2020
Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020)original ↗
3 Feb 2020
Hacking Session: Troubleshooting Complex Oracle Performance Problems (January 2020)original ↗
30 Jan 2020
help.sql: Show TPT Script Purpose and Syntaxoriginal ↗
15 Jan 2020
Oracle State Objects and Reading System State Dumps Hacking Session Videooriginal ↗
9 Jan 2020

2019

New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1)original ↗
4 Oct 2019
Dump Current Oracle SQL Execution Plan Line ID Using Oradebugoriginal ↗
8 Apr 2019
pSnapper: Linux Process Snapper Page and Videosoriginal ↗
3 Apr 2019
Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT)original ↗
1 Apr 2019
What Caused This Wait Event: Using Oracle's wait_event[] tracingoriginal ↗
29 Mar 2019
Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds?original ↗
7 Mar 2019
Practical Linux Performance & Application Troubleshooting Training Details and Table of Contentsoriginal ↗
4 Mar 2019

2018

Scripts for Drilling Down Into Unknown Optimizer Changesoriginal ↗
9 Nov 2018
Visualizing SQL Plan Execution Time With FlameGraphsoriginal ↗
28 Oct 2018
Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed)original ↗
10 Oct 2018
Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progressoriginal ↗
8 Oct 2018
Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!original ↗
29 Aug 2018
Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!original ↗
21 Aug 2018
Webinar: Troubleshooting a Complex Oracle Performance Issueoriginal ↗
7 Jun 2018
My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourcedoriginal ↗
18 May 2018
Video: Oracle X$TRACE, Wait Event Internals and Background Process Communicationoriginal ↗
25 Jan 2018
Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing toooriginal ↗
11 Jan 2018

2017

Advanced Oracle Troubleshooting seminar in 2018!original ↗
29 Nov 2017
Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Monthoriginal ↗
11 Jul 2017

2016

GNW01: In-Memory Processing for Databasesoriginal ↗
28 Mar 2016
My BIWA Summit Presentationsoriginal ↗
26 Jan 2016

2015

RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cyclesoriginal ↗
30 Nov 2015
My New Youtube Channeloriginal ↗
24 Nov 2015
Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contentionoriginal ↗
11 Nov 2015
SQL Monitoring in Oracle Database 12coriginal ↗
29 Oct 2015
Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)original ↗
9 Oct 2015
RAM is the new disk – and how to measure its performance – Part 2 – Toolsoriginal ↗
21 Sept 2015
RAM is the new disk – and how to measure its performance – Part 1 – Introductionoriginal ↗
9 Aug 2015
The Hybrid World is Comingoriginal ↗
29 Jun 2015
Old ventures and new adventuresoriginal ↗
19 Jun 2015
Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits?original ↗
24 Apr 2015
Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variableoriginal ↗
29 Mar 2015
Next