corpus.blog
41554 blogs · [ { "id": "01a087e9-67f7-7082-b607-53be5eb1ba39", "title": "Oracle Session Snapper v3.10", "url": "https://tanelpoder.com/2010/03/22/oracle-session-snapper-v3-10/", "published_at": "2010-03-22T16:35:50+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5ee27b4c", "title": "How to CANCEL a query running in another session?", "url": "https://tanelpoder.com/2010/02/17/how-to-cancel-a-query-running-in-another-session/", "published_at": "2010-02-18T04:14:54+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5fe05e27", "title": "New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning", "url": "https://tanelpoder.com/2010/02/15/new-versions-of-latchprof-and-latchprofx-for-latch-contention-troubleshooting-and-tuning/", "published_at": "2010-02-16T03:01:51+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be60a206ea", "title": "Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!", "url": "https://tanelpoder.com/2010/02/14/oracle-troubleshooting-how-to-read-oracle-errorstack-output/", "published_at": "2010-02-14T18:41:46+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be614c249b", "title": "Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris", "url": "https://tanelpoder.com/2010/02/11/using-process-memory-matrix-script-for-calculating-oracle-process-memory-usage-on-solaris/", "published_at": "2010-02-11T18:21:04+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be62344189", "title": "Oracle Wait Event reference", "url": "https://tanelpoder.com/2010/02/09/oracle-wait-event-reference/", "published_at": "2010-02-09T10:35:57+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be62fdb318", "title": "Oracle Peformance Visualization…", "url": "https://tanelpoder.com/2010/02/03/oracle-peformance-visualization/", "published_at": "2010-02-03T09:47:42+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be633e5d2e", "title": "Bind Variable Peeking – execution plan inefficiency", "url": "https://tanelpoder.com/2010/02/02/bind-variable-peeking-execution-plan-inefficiency/", "published_at": "2010-02-02T17:11:34+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be63bc0efa", "title": "Recursive sessions…", "url": "https://tanelpoder.com/2010/01/21/recursive-sessions-2/", "published_at": "2010-01-22T04:43:29+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be647f0c1b", "title": "Sometimes things are easy (Part 1): How to fix wrapped execution plan text?", "url": "https://tanelpoder.com/2010/01/18/sometimes-things-are-easy-part-1-how-to-fix-wrapped-execution-plan-text/", "published_at": "2010-01-18T16:26:33+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be64a1f119", "title": "Beyond Oracle Wait Interface – Part 2", "url": "https://tanelpoder.com/2010/01/15/beyond-oracle-wait-interface-part-2/", "published_at": "2010-01-15T10:53:57+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be651dc09a", "title": "NULL is not zero!", "url": "https://tanelpoder.com/2009/12/30/null-is-not-zero/", "published_at": "2009-12-30T06:48:15+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be66059794", "title": "Measuring what matters", "url": "https://tanelpoder.com/2009/12/22/measuring-what-matters/", "published_at": "2009-12-23T00:58:39+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6633b155", "title": "Finding the reasons for excessive logical IOs", "url": "https://tanelpoder.com/2009/11/19/finding-the-reasons-for-excessive-logical-ios/", "published_at": "2009-11-19T17:16:38+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be66dba333", "title": "Explain Plan For command may show you the wrong execution plan – Part 1", "url": "https://tanelpoder.com/2009/11/17/explain-plan-for-command-may-show-you-the-wrong-execution-plan-part-1/", "published_at": "2009-11-18T02:33:24+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be67941639", "title": "Detect chained and migrated rows in Oracle – Part 1", "url": "https://tanelpoder.com/2009/11/04/detect-chained-and-migrated-rows-in-oracle/", "published_at": "2009-11-04T22:34:47+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be681f9f76", "title": "What’s a good way to learn some Oracle internals every day?", "url": "https://tanelpoder.com/2009/10/26/whats-a-good-way-to-learn-some-oracle-internals-every-day/", "published_at": "2009-10-26T16:11:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be68ab3334", "title": "SystemTap is production supported in Redhat EL5.4", "url": "https://tanelpoder.com/2009/10/25/systemtap-is-production-supported-in-redhat-el5-4/", "published_at": "2009-10-25T15:53:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be68ca3d9b", "title": "KGL simulator, shared pool simulator and buffer cache simulator – what are these?", "url": "https://tanelpoder.com/2009/09/13/kgl-simulator-shared-pool-simulator-and-buffer-cache-simulator-what-are-these/", "published_at": "2009-09-14T00:13:39+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6973e3c9", "title": "KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!", "url": "https://tanelpoder.com/2009/09/09/kgh-no-access-allocations-in-vsgastat-buffer-cache-within-shared-pool/", "published_at": "2009-09-09T15:05:49+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6a306273", "title": "Oracle 11gR2 has been released – and with column oriented storage option", "url": "https://tanelpoder.com/2009/09/01/oracle-11gr2-has-been-released-and-with-column-oriented-storage-option/", "published_at": "2009-09-01T18:07:05+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6ad550e9", "title": "latch: cache buffers chains latch contention – a better way for finding the hot block", "url": "https://tanelpoder.com/2009/08/27/latch-cache-buffers-chains-latch-contention-a-better-way-for-finding-the-hot-block/", "published_at": "2009-08-27T09:37:08+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6bc64628", "title": "Select COUNT(*) and COUNT(column) are different things!", "url": "https://tanelpoder.com/2009/08/21/select-count-and-countcolumn-are-different-things/", "published_at": "2009-08-22T03:58:19+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6c35e0f0", "title": "Alter system kill session and ORA-00031: session marked for kill", "url": "https://tanelpoder.com/2009/08/13/alter-system-kill-session-and-ora-00031-session-marked-for-kill/", "published_at": "2009-08-13T07:22:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6d1733c2", "title": "An interview with me", "url": "https://tanelpoder.com/2009/08/09/an-interview-with-me/", "published_at": "2009-08-10T01:56:46+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6d5327d2", "title": "How to detect when a cursor was closed from SQL trace output?", "url": "https://tanelpoder.com/2009/07/09/how-to-detect-when-a-cursor-was-closed-from-sql-trace-output/", "published_at": "2009-07-09T11:50:07+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6dae836c", "title": "Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile", "url": "https://tanelpoder.com/2009/07/09/identify-the-sql-statement-causing-those-wait-x-lines-in-a-top-truncated-sql-tracefile/", "published_at": "2009-07-09T09:44:40+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6e7c9250", "title": "(Secret) Preview of Oracle 12g CBO leaked from Oracle labs…", "url": "https://tanelpoder.com/2009/06/27/secret-preview-oracle-12g-cbo-leaked-from-oracle-labs/", "published_at": "2009-06-27T07:13:54+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6f6be2bd", "title": "Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump", "url": "https://tanelpoder.com/2009/06/24/oracle-memory-troubleshooting-part-3-automatic-top-subheap-dumping-with-heapdump/", "published_at": "2009-06-24T12:31:07+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be6f7cce3d", "title": "Using Perfsheet and TPT scripts for solving real life performance problems", "url": "https://tanelpoder.com/2009/06/09/using-perfsheet-and-tpt-scripts-for-solving-real-life-performance-problems/", "published_at": "2009-06-09T22:27:52+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be706d4fbd", "title": "ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql", "url": "https://tanelpoder.com/2009/06/04/ora-04031-errors-and-monitoring-shared-pool-subpool-memory-utilization-with-sgastatxsql/", "published_at": "2009-06-04T22:24:11+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be708244af", "title": "Oracle Performance Visualization videos from Sydney", "url": "https://tanelpoder.com/2009/05/27/oracle-performance-visualization-videos-from-sydney/", "published_at": "2009-05-27T13:18:31+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be71175707", "title": "Scripts for showing execution plans via plain SQL and also in Oracle 9i", "url": "https://tanelpoder.com/2009/05/26/scripts-for-showing-execution-plans-via-plain-sql-and-also-in-oracle-9i/", "published_at": "2009-05-26T20:42:05+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be714aa594", "title": "“Free” DBA_HIST AWR views in 11g…", "url": "https://tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/", "published_at": "2009-05-06T15:36:12+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be71913b27", "title": "I have been troubleshooting since I was a kid! :)", "url": "https://tanelpoder.com/2009/05/01/i-have-been-troubleshooting-since-i-was-a-kid/", "published_at": "2009-05-01T13:02:57+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be727f616e", "title": "Tracing Oracle SQL plan execution with DTrace", "url": "https://tanelpoder.com/2009/04/24/tracing-oracle-sql-plan-execution-with-dtrace/", "published_at": "2009-04-24T06:11:48+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be735a3069", "title": "Seminar feedback and pictures from Singapore", "url": "https://tanelpoder.com/2009/04/20/seminar-feedback-and-pictures-from-singapore/", "published_at": "2009-04-20T10:54:43+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be739e4415", "title": "Read OS environment variables using DBMS_SYSTEM.GET_ENV()", "url": "https://tanelpoder.com/2009/03/27/read-os-environment-variables-using-dbms_systemget_env/", "published_at": "2009-03-27T17:28:58+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7444d55e", "title": "I’m an Oracle ACE Director now :)", "url": "https://tanelpoder.com/2009/03/26/im-an-oracle-ace-director-now/", "published_at": "2009-03-27T00:46:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7496e0b5", "title": "Oracle 11g: Reading alert log via SQL", "url": "https://tanelpoder.com/2009/03/21/oracle-11g-reading-alert-log-via-sql/", "published_at": "2009-03-22T01:38:15+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be74fab302", "title": "Another LatchProfX use case", "url": "https://tanelpoder.com/2009/03/20/another-latchprofx-use-case/", "published_at": "2009-03-20T19:35:41+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be74fc61de", "title": "The real history of Oracle database revealed!", "url": "https://tanelpoder.com/2009/03/14/the-real-history-of-oracle-database-revealed/", "published_at": "2009-03-14T05:36:40+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7503f36b", "title": "Oracle, Timesten and PL/SQL support", "url": "https://tanelpoder.com/2009/03/06/oracle-timesten-and-plsql-support/", "published_at": "2009-03-07T01:09:56+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be75f93a67", "title": "The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling", "url": "https://tanelpoder.com/2009/03/03/the-full-power-of-oracles-diagnostic-events-part-1-syntax-for-ksd-debug-event-handling/", "published_at": "2009-03-04T00:21:01+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be76f0c6f3", "title": "60000 bind variables?! Maybe it’s time to use a temporary table instead…", "url": "https://tanelpoder.com/2009/02/25/60000-bind-variables-maybe-its-time-to-use-a-temporary-table-instead/", "published_at": "2009-02-25T06:58:59+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7757caa5", "title": "SQL_ID is just a fancy representation of hash value", "url": "https://tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value/", "published_at": "2009-02-22T21:02:12+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be77d694c8", "title": "Performance Visualization, Capacity planning and Hotsos Symposium", "url": "https://tanelpoder.com/2009/02/14/performance-visualization-capacity-planning-and-hotsos-symposium/", "published_at": "2009-02-14T21:29:06+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7811f3de", "title": "When was a table last changed?", "url": "https://tanelpoder.com/2009/02/07/when-was-a-table-last-changed/", "published_at": "2009-02-08T00:32:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7814cc42", "title": "Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint", "url": "https://tanelpoder.com/2009/01/23/multipart-cursor-subexecution-and-precompute_subquery-hint/", "published_at": "2009-01-23T21:38:11+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be787a44db", "title": "Identifying shared memory segment users using lsof", "url": "https://tanelpoder.com/2009/01/22/identifying-shared-memory-segment-users-using-lsof/", "published_at": "2009-01-22T12:42:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be79099af6", "title": "Reliable latch waits and a new blog", "url": "https://tanelpoder.com/2009/01/20/reliable-latch-waits-and-a-new-blog/", "published_at": "2009-01-20T09:12:16+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be79e98264", "title": "Oracle memory troubleshooting, Part 1: Heapdump Analyzer", "url": "https://tanelpoder.com/2009/01/02/oracle-memory-troubleshooting-part-1-heapdump-analyzer/", "published_at": "2009-01-02T11:55:36+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7aa45ea0", "title": "Performance Visualization made easy – PerfSheet 2.0 beta", "url": "https://tanelpoder.com/2008/12/28/performance-visualization-made-easy-perfsheet-20-beta/", "published_at": "2008-12-28T15:19:36+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7b8bc3a2", "title": "A little oradebug enhancement in Oracle 11g", "url": "https://tanelpoder.com/2008/11/03/little-oradebug-enhancement-in-oracle-11g/", "published_at": "2008-11-02T18:47:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7c3e8957", "title": "Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProf", "url": "https://tanelpoder.com/2008/10/31/advanced-oracle-troubleshooting-guide-part-9-process-stack-profiling-from-sqlplus-using-ostackprof/", "published_at": "2008-10-31T01:02:17+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7cf8eb01", "title": "Transportable tablespaces and ROWID uniqueness", "url": "https://tanelpoder.com/2008/10/21/transportable-tablespaces-and-rowid-uniqueness/", "published_at": "2008-10-21T01:25:29+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7d25c93d", "title": "VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles", "url": "https://tanelpoder.com/2008/09/05/vldb-2008-proceedings-oracle-optimizer-plan-stability-adaptive-cursor-sharing-and-securefiles/", "published_at": "2008-09-05T12:11:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7d866f67", "title": "Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others", "url": "https://tanelpoder.com/2008/09/02/oracle-hidden-costs-revealed-part2-using-dtrace-to-find-why-writes-in-system-tablespace-are-slower-than-in-others/", "published_at": "2008-09-01T17:16:50+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7e1579a7", "title": "Flexible sampling of any V$ or X$ view with sample.sql", "url": "https://tanelpoder.com/2008/08/26/flexible-sampling-of-any-v-or-x-view-with-samplesql/", "published_at": "2008-08-26T10:35:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7e7fafae", "title": "Case study on some rowcache internals, cached non-existent objects and a describe bug", "url": "https://tanelpoder.com/2008/08/18/case-study-on-some-rowcache-internals-cached-non-existent-objects-and-a-describe-bug/", "published_at": "2008-08-18T12:37:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7e8ceda1", "title": "Why does even a small difference in SQL text cause a hard parse?", "url": "https://tanelpoder.com/2008/08/15/why-does-even-a-small-difference-in-sql-text-cause-a-hard-parse/", "published_at": "2008-08-14T18:45:52+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7f191f3d", "title": "Script: Display valid values for multioption parameters (including hidden parameters)", "url": "https://tanelpoder.com/2008/08/13/script-display-valid-values-for-multioption-parameters-including-hidden-parameters/", "published_at": "2008-08-12T18:16:58+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be7f81e11c", "title": "The simplest query for checking what’s happening in a database", "url": "https://tanelpoder.com/2008/08/07/the-simplest-query-for-checking-whats-happening-in-a-database/", "published_at": "2008-08-06T16:30:43+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be805def73", "title": "Library cache latches gone in Oracle 11g", "url": "https://tanelpoder.com/2008/08/03/library-cache-latches-gone-in-oracle-11g/", "published_at": "2008-08-02T19:54:34+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be80d141ae", "title": "Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX", "url": "https://tanelpoder.com/2008/07/23/advanced-oracle-troubleshooting-guide-part-8-even-more-detailed-latch-troubleshooting-using-latchprofx/", "published_at": "2008-07-22T16:58:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be81cf1df4", "title": "Closed database and WITH subquery", "url": "https://tanelpoder.com/2008/07/14/closed-database-and-with-subquery/", "published_at": "2008-07-14T11:17:07+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be81fd130a", "title": "Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf", "url": "https://tanelpoder.com/2008/07/09/advanced-oracle-troubleshooting-guide-part-7-sampling-latch-holder-statistics-using-latchprof/", "published_at": "2008-07-08T11:54:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be820d3b86", "title": "Another use case for WaitProf – diagnosing “events in waitclass Other”", "url": "https://tanelpoder.com/2008/06/21/another-use-case-for-waitprof-diagnosing-events-in-waitclass-other/", "published_at": "2008-06-20T16:46:47+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be82f84957", "title": "Killing an Oracle process from inside Oracle", "url": "https://tanelpoder.com/2008/06/19/killing-an-oracle-process-from-inside-oracle/", "published_at": "2008-06-19T11:44:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8368a654", "title": "cursor_space_for_time To Be Deprecated", "url": "https://tanelpoder.com/2008/06/17/cursor_space_for_time-to-be-deprecated/", "published_at": "2008-06-17T10:52:55+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be837f6503", "title": "Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain", "url": "https://tanelpoder.com/2008/06/15/advanced-oracle-troubleshooting-guide-part-6-understanding-oracle-execution-plans-with-os_explain/", "published_at": "2008-06-15T14:40:12+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be839f3854", "title": "Debugger dangers", "url": "https://tanelpoder.com/2008/06/14/debugger-dangers/", "published_at": "2008-06-14T11:51:54+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be83cff569", "title": "Short note on KGX Mutexes", "url": "https://tanelpoder.com/2008/06/12/short-note-on-kgx-mutexes/", "published_at": "2008-06-12T15:01:14+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be840652b2", "title": "Generating lots of rows using connect by – safely!", "url": "https://tanelpoder.com/2008/06/08/generating-lots-of-rows-using-connect-by-safely/", "published_at": "2008-06-08T09:06:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be842ea7d6", "title": "Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!", "url": "https://tanelpoder.com/2008/06/06/advanced-oracle-troubleshooting-guide-part-5-sampling-v-stuff-with-waitprof-really-fast-using-sql/", "published_at": "2008-06-05T17:11:42+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be850a6a0d", "title": "Performance Tools Quick Reference Guide", "url": "https://tanelpoder.com/2008/06/03/performance-tools-quick-reference-guide/", "published_at": "2008-06-02T18:09:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be85d78dc3", "title": "Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue", "url": "https://tanelpoder.com/2008/06/03/advanced-oracle-troubleshooting-guide-part-4-diagnosing-a-long-parsing-issue/", "published_at": "2008-06-02T18:00:38+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be85db30a6", "title": "Snapper shortcut", "url": "https://tanelpoder.com/2008/06/02/snapper-shortcut/", "published_at": "2008-06-02T15:05:02+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be86d3f44b", "title": "Querying the current tracefile name, using SQL – with tracefile_identifier", "url": "https://tanelpoder.com/2008/05/31/querying-the-current-tracefile-name-using-sql-with-tracefile_identifier/", "published_at": "2008-05-30T17:41:22+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be87acd6b4", "title": "Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation", "url": "https://tanelpoder.com/2008/05/30/oracle-troubleshooting-with-snapper-detecting-whos-causing-excessive-redo-generation/", "published_at": "2008-05-30T14:13:38+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be88a9e0d3", "title": "Performance and Scalalability Improvements in Oracle 10g and 11g", "url": "https://tanelpoder.com/2008/05/25/performance-and-scalalability-improvements-in-oracle-10g-and-11g/", "published_at": "2008-05-25T12:08:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be894df834", "title": "Using autonomous transactions for sleeping", "url": "https://tanelpoder.com/2008/05/25/using-autonomous-transactions-for-sleeping/", "published_at": "2008-05-25T09:52:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8954a470", "title": "SQL*Net break/reset to client", "url": "https://tanelpoder.com/2008/04/10/sqlnet-breakreset-to-client/", "published_at": "2008-04-09T16:50:49+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be895581db", "title": "SQL*Net message to client vs SQL*Net more data to client", "url": "https://tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/", "published_at": "2008-02-10T07:35:58+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8a4e509e", "title": "SQL*Net message to client wait isn’t really what it’s thought to be", "url": "https://tanelpoder.com/2008/02/07/sqlnet-message-to-client-wait-gotcha/", "published_at": "2008-02-07T08:35:47+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8a8d1aa9", "title": "Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally?", "url": "https://tanelpoder.com/2008/02/05/oracle-hidden-costs-revealed-part-1/", "published_at": "2008-02-04T16:09:06+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8b32a99e", "title": "Excellent article on Oracle 11g PL/SQL function result cache", "url": "https://tanelpoder.com/2008/02/03/oracle-11g-plsql-function-result-cache/", "published_at": "2008-02-03T07:39:25+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8bea1a54", "title": "Can you write a working SQL statement without using any whitespace?", "url": "https://tanelpoder.com/2008/01/14/can-you-write-a-working-sql-statement-without-using-any-whitespace/", "published_at": "2008-01-14T04:42:21+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8c4b1138", "title": "Expensive calculator…", "url": "https://tanelpoder.com/2008/01/09/expensive-calculator/", "published_at": "2008-01-09T09:53:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8c7019dd", "title": "Why does Oracle parameter count change during session lifetime?", "url": "https://tanelpoder.com/2008/01/07/why-does-oracle-parameter-count-change-during-session-lifetime/", "published_at": "2008-01-07T11:36:33+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8c8e6b9f", "title": "Systematic application troubleshooting in Unix", "url": "https://tanelpoder.com/2008/01/05/systematic-application-troubleshooting-in-unix/", "published_at": "2008-01-05T11:55:59+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8d40b239", "title": "Perl version of Snapper", "url": "https://tanelpoder.com/2007/12/28/perl-version-of-snapper/", "published_at": "2007-12-28T15:44:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8d7f3852", "title": "Sqlplus is my second home, part 5: Reading the name of currently executing script", "url": "https://tanelpoder.com/2007/12/26/sqlplus-is-my-second-home-part-5-reading-the-name-of-currently-executing-script/", "published_at": "2007-12-25T16:00:35+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8e0e0336", "title": "Oracle Security, Part 2: Your read only accounts aren’t that read only", "url": "https://tanelpoder.com/2007/11/19/oracle-security-part-2-your-read-only-accounts-arent-that-read-only/", "published_at": "2007-11-18T16:44:56+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8e698b9e", "title": "Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable", "url": "https://tanelpoder.com/2007/11/07/sqlplus-is-my-second-home-part-4-getting-sqlplus-parameter-value-into-a-variable/", "published_at": "2007-11-06T16:22:12+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be8f3b5908", "title": "A simple interview question", "url": "https://tanelpoder.com/2007/10/20/a-simple-interview-question/", "published_at": "2007-10-19T16:20:28+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be901c2421", "title": "How to resolve SQL object and column names all the way to base tables and columns in Oracle?", "url": "https://tanelpoder.com/2007/09/16/how-to-resolve-sql-object-and-column-names-all-the-way-to-base-tables-and-columns-in-oracle/", "published_at": "2007-09-16T05:23:08+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be906ae3d5", "title": "Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stack", "url": "https://tanelpoder.com/2007/09/06/advanced-oracle-troubleshooting-guide-part-3-more-adventures-in-process-stack/", "published_at": "2007-09-05T16:50:32+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be910a63a4", "title": "Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt", "url": "https://tanelpoder.com/2007/09/01/sqlplus-is-my-second-home-part-3-colored-selections-in-windows-xp-command-prompt/", "published_at": "2007-09-01T05:55:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be918d91ef", "title": "Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP", "url": "https://tanelpoder.com/2007/08/31/sqlplus-is-my-second-home-part2/", "published_at": "2007-08-30T16:11:20+00:00" } ] posts Claim your blog
Back to tanelpoder
Blog · corpus.blog/blogs/tanelpoder.com/posts

tanelpoder

tanelpoder.com

2010

Oracle Session Snapper v3.10original ↗
22 Mar 2010
How to CANCEL a query running in another session?original ↗
18 Feb 2010
New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuningoriginal ↗
16 Feb 2010
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!original ↗
14 Feb 2010
Using Process Memory Matrix script for calculating Oracle process memory usage on Solarisoriginal ↗
11 Feb 2010
Oracle Wait Event referenceoriginal ↗
9 Feb 2010
Oracle Peformance Visualization…original ↗
3 Feb 2010
Bind Variable Peeking – execution plan inefficiencyoriginal ↗
2 Feb 2010
Recursive sessions…original ↗
22 Jan 2010
Sometimes things are easy (Part 1): How to fix wrapped execution plan text?original ↗
18 Jan 2010
Beyond Oracle Wait Interface – Part 2original ↗
15 Jan 2010

2009

NULL is not zero!original ↗
30 Dec 2009
Measuring what mattersoriginal ↗
23 Dec 2009
Finding the reasons for excessive logical IOsoriginal ↗
19 Nov 2009
Explain Plan For command may show you the wrong execution plan – Part 1original ↗
18 Nov 2009
Detect chained and migrated rows in Oracle – Part 1original ↗
4 Nov 2009
What’s a good way to learn some Oracle internals every day?original ↗
26 Oct 2009
SystemTap is production supported in Redhat EL5.4original ↗
25 Oct 2009
KGL simulator, shared pool simulator and buffer cache simulator – what are these?original ↗
14 Sept 2009
KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!original ↗
9 Sept 2009
Oracle 11gR2 has been released – and with column oriented storage optionoriginal ↗
1 Sept 2009
latch: cache buffers chains latch contention – a better way for finding the hot blockoriginal ↗
27 Aug 2009
Select COUNT(*) and COUNT(column) are different things!original ↗
22 Aug 2009
Alter system kill session and ORA-00031: session marked for killoriginal ↗
13 Aug 2009
An interview with meoriginal ↗
10 Aug 2009
How to detect when a cursor was closed from SQL trace output?original ↗
9 Jul 2009
Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefileoriginal ↗
9 Jul 2009
(Secret) Preview of Oracle 12g CBO leaked from Oracle labs…original ↗
27 Jun 2009
Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdumporiginal ↗
24 Jun 2009
Using Perfsheet and TPT scripts for solving real life performance problemsoriginal ↗
9 Jun 2009
ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sqloriginal ↗
4 Jun 2009
Oracle Performance Visualization videos from Sydneyoriginal ↗
27 May 2009
Scripts for showing execution plans via plain SQL and also in Oracle 9ioriginal ↗
26 May 2009
“Free” DBA_HIST AWR views in 11g…original ↗
6 May 2009
I have been troubleshooting since I was a kid! :)original ↗
1 May 2009
Tracing Oracle SQL plan execution with DTraceoriginal ↗
24 Apr 2009
Seminar feedback and pictures from Singaporeoriginal ↗
20 Apr 2009
Read OS environment variables using DBMS_SYSTEM.GET_ENV()original ↗
27 Mar 2009
I’m an Oracle ACE Director now :)original ↗
27 Mar 2009
Oracle 11g: Reading alert log via SQLoriginal ↗
22 Mar 2009
Another LatchProfX use caseoriginal ↗
20 Mar 2009
The real history of Oracle database revealed!original ↗
14 Mar 2009
Oracle, Timesten and PL/SQL supportoriginal ↗
7 Mar 2009
The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handlingoriginal ↗
4 Mar 2009
60000 bind variables?! Maybe it’s time to use a temporary table instead…original ↗
25 Feb 2009
SQL_ID is just a fancy representation of hash valueoriginal ↗
22 Feb 2009
Performance Visualization, Capacity planning and Hotsos Symposiumoriginal ↗
14 Feb 2009
When was a table last changed?original ↗
8 Feb 2009
Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hintoriginal ↗
23 Jan 2009
Identifying shared memory segment users using lsoforiginal ↗
22 Jan 2009
Reliable latch waits and a new blogoriginal ↗
20 Jan 2009
Oracle memory troubleshooting, Part 1: Heapdump Analyzeroriginal ↗
2 Jan 2009

2008

Performance Visualization made easy – PerfSheet 2.0 betaoriginal ↗
28 Dec 2008
A little oradebug enhancement in Oracle 11goriginal ↗
2 Nov 2008
Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProforiginal ↗
31 Oct 2008
Transportable tablespaces and ROWID uniquenessoriginal ↗
21 Oct 2008
VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFilesoriginal ↗
5 Sept 2008
Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in othersoriginal ↗
1 Sept 2008
Flexible sampling of any V$ or X$ view with sample.sqloriginal ↗
26 Aug 2008
Case study on some rowcache internals, cached non-existent objects and a describe bugoriginal ↗
18 Aug 2008
Why does even a small difference in SQL text cause a hard parse?original ↗
14 Aug 2008
Script: Display valid values for multioption parameters (including hidden parameters)original ↗
12 Aug 2008
The simplest query for checking what’s happening in a databaseoriginal ↗
6 Aug 2008
Library cache latches gone in Oracle 11goriginal ↗
2 Aug 2008
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfXoriginal ↗
22 Jul 2008
Closed database and WITH subqueryoriginal ↗
14 Jul 2008
Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProforiginal ↗
8 Jul 2008
Another use case for WaitProf – diagnosing “events in waitclass Other”original ↗
20 Jun 2008
Killing an Oracle process from inside Oracleoriginal ↗
19 Jun 2008
cursor_space_for_time To Be Deprecatedoriginal ↗
17 Jun 2008
Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explainoriginal ↗
15 Jun 2008
Debugger dangersoriginal ↗
14 Jun 2008
Short note on KGX Mutexesoriginal ↗
12 Jun 2008
Generating lots of rows using connect by – safely!original ↗
8 Jun 2008
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!original ↗
5 Jun 2008
Performance Tools Quick Reference Guideoriginal ↗
2 Jun 2008
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issueoriginal ↗
2 Jun 2008
Snapper shortcutoriginal ↗
2 Jun 2008
Querying the current tracefile name, using SQL – with tracefile_identifieroriginal ↗
30 May 2008
Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generationoriginal ↗
30 May 2008
Performance and Scalalability Improvements in Oracle 10g and 11goriginal ↗
25 May 2008
Using autonomous transactions for sleepingoriginal ↗
25 May 2008
SQL*Net break/reset to clientoriginal ↗
9 Apr 2008
SQL*Net message to client vs SQL*Net more data to clientoriginal ↗
10 Feb 2008
SQL*Net message to client wait isn’t really what it’s thought to beoriginal ↗
7 Feb 2008
Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally?original ↗
4 Feb 2008
Excellent article on Oracle 11g PL/SQL function result cacheoriginal ↗
3 Feb 2008
Can you write a working SQL statement without using any whitespace?original ↗
14 Jan 2008
Expensive calculator…original ↗
9 Jan 2008
Why does Oracle parameter count change during session lifetime?original ↗
7 Jan 2008
Systematic application troubleshooting in Unixoriginal ↗
5 Jan 2008

2007

Perl version of Snapperoriginal ↗
28 Dec 2007
Sqlplus is my second home, part 5: Reading the name of currently executing scriptoriginal ↗
25 Dec 2007
Oracle Security, Part 2: Your read only accounts aren’t that read onlyoriginal ↗
18 Nov 2007
Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variableoriginal ↗
6 Nov 2007
A simple interview questionoriginal ↗
19 Oct 2007
How to resolve SQL object and column names all the way to base tables and columns in Oracle?original ↗
16 Sept 2007
Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stackoriginal ↗
5 Sept 2007
Sqlplus is my second home, part 3: Colored selections in Windows XP command promptoriginal ↗
1 Sept 2007
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTPoriginal ↗
30 Aug 2007
Previous Next