corpus.blog
56,966 blogs · [ { "id": "01a087e9-67f7-7082-b607-53be2eab25f0", "title": "Oracle Exadata Performance: Latest Improvements and Less Known Features", "url": "https://tanelpoder.com/2015/03/24/oracle-exadata-performance-latest-improvements-and-less-known-features/", "published_at": "2015-03-24T14:57:51+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2f3e6e6d", "title": "Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used?", "url": "https://tanelpoder.com/2014/10/05/oracle-in-memory-column-store-internals-part-1-which-simd-extensions-are-getting-used/", "published_at": "2014-10-06T05:51:30+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be2f4dbbd4", "title": "About index range scans, disk re-reads and how your new car can go 600 miles per hour!", "url": "https://tanelpoder.com/2014/09/17/about-index-range-scans-disk-re-reads-and-how-your-new-car-can-go-600-miles-per-hour/", "published_at": "2014-09-17T08:56:02+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be30231e0c", "title": "Combining Bloom Filter Offloading and Storage Indexes on Exadata", "url": "https://tanelpoder.com/2014/05/17/combining-bloom-filter-offloading-and-storage-indexes-on-exadata/", "published_at": "2014-05-18T04:15:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3112a093", "title": "What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux?", "url": "https://tanelpoder.com/2014/05/09/what-the-heck-are-the-devshmjoxshm_ext_x-files-on-linux/", "published_at": "2014-05-09T20:12:01+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be31825e27", "title": "Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL", "url": "https://tanelpoder.com/2014/03/26/oracle-memory-troubleshooting-part-4-drilling-down-into-pga-memory-usage-with-vprocess_memory_detail/", "published_at": "2014-03-26T22:58:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3196db34", "title": "Slides of my previous presentations", "url": "https://tanelpoder.com/2014/03/06/slides-of-my-previous-presentations/", "published_at": "2014-03-06T13:57:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3236a1ba", "title": "Where does the Exadata storage() predicate come from?", "url": "https://tanelpoder.com/2014/03/05/where-does-the-exadata-storage-predicate-come-from/", "published_at": "2014-03-05T19:49:53+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be32aada7e", "title": "Oracle X$ tables – Part 1 – Where do they get their data from?", "url": "https://tanelpoder.com/2014/01/10/oracle-x-tables-part-1-where-do-they-get-their-data-from/", "published_at": "2014-01-10T19:38:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be33069463", "title": "cell flash cache read hits vs. cell writes to flash cache statistics on Exadata", "url": "https://tanelpoder.com/2013/12/04/cell-flash-cache-read-hits-vs-cell-writes-to-flash-cache-statistics-on-exadata/", "published_at": "2013-12-04T11:57:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be33dc135c", "title": "Hard Drive Predictive Failures on Linux and Exadata", "url": "https://tanelpoder.com/2013/11/29/hard-drive-predictive-failures-on-exadata/", "published_at": "2013-11-29T12:50:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3494a1a8", "title": "When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?", "url": "https://tanelpoder.com/2013/11/27/when-do-oracle-parallel-execution-slaves-issue-buffered-physical-reads-part-2/", "published_at": "2013-11-27T11:32:36+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be34ae986f", "title": "When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?", "url": "https://tanelpoder.com/2013/11/27/when-do-oracle-parallel-execution-slaves-issue-buffered-physical-reads-part-1/", "published_at": "2013-11-27T10:32:38+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be34d1dd2d", "title": "Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)", "url": "https://tanelpoder.com/2013/11/06/diagnosing-buffer-busy-waits-with-the-ash_wait_chains-sql-script-v0-2/", "published_at": "2013-11-07T01:54:01+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be358beedb", "title": "SGA bigger than the amount of HugePages configured (Linux – 11.2.0.3)", "url": "https://tanelpoder.com/2013/10/25/sga-bigger-than-than-the-amount-of-hugepages-configured-linux-11-2-0-3/", "published_at": "2013-10-25T13:23:24+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be35bbf75e", "title": "Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately?", "url": "https://tanelpoder.com/2013/10/07/why-doesnt-alter-system-set-events-set-the-events-or-tracing-immediately/", "published_at": "2013-10-07T15:23:22+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be35bca279", "title": "Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql", "url": "https://tanelpoder.com/2013/09/11/advanced-oracle-troubleshooting-guide-part-11-complex-wait-chain-signature-analysis-with-ash_wait_chains-sql/", "published_at": "2013-09-12T01:23:35+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be367fadf0", "title": "Oracle Performance & Troubleshooting Online Seminars in 2013", "url": "https://tanelpoder.com/2013/09/05/oracle-performance-troubleshooting-online-seminars-in-2013/", "published_at": "2013-09-05T13:45:07+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be373e81b4", "title": "Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)", "url": "https://tanelpoder.com/2013/08/22/scalar-subqueries-in-oracle-sql-where-clauses-and-a-little-bit-of-exadata-stuff-too/", "published_at": "2013-08-22T21:03:25+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3769af0f", "title": "ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support", "url": "https://tanelpoder.com/2013/08/19/c-mos-how-to-get-rid-of-the-annoying-the-page-has-expired-dialog-in-my-oracle-support/", "published_at": "2013-08-19T12:00:58+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be378997a0", "title": "Oracle 12c: Scalar Subquery Unnesting transformation", "url": "https://tanelpoder.com/2013/08/13/oracle-12c-scalar-subquery-unnesting-transformation/", "published_at": "2013-08-13T14:55:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be37bfbff2", "title": "Oracle Database 12c R1 (12.1.0.1.0) is finally released!", "url": "https://tanelpoder.com/2013/06/25/oracle-database-12c-r1-12-1-0-1-0-is-finally-released/", "published_at": "2013-06-25T18:39:46+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be37fc7669", "title": "Getting the Most Out of ASH online seminar", "url": "https://tanelpoder.com/2013/06/05/getting-the-most-out-of-ash-online-seminar/", "published_at": "2013-06-05T21:10:35+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be38a4e5b1", "title": "Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production?", "url": "https://tanelpoder.com/2013/05/29/forcing-smart-scans-on-exadata-is-_serial_direct_read-parameter-safe-to-use-in-production/", "published_at": "2013-05-29T12:38:14+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be38d22757", "title": "Debugger Dangers – Part 2", "url": "https://tanelpoder.com/2013/05/27/debugger-dangers-part-2/", "published_at": "2013-05-27T17:31:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be396a916d", "title": "List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts", "url": "https://tanelpoder.com/2013/05/24/list-exadata-storage-cell-disk-summary-with-cellpd-sql-and-cellpdx-sql-scripts/", "published_at": "2013-05-24T20:05:50+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3a3a2870", "title": "List Exadata Disk Layout and Topology with the exadisktopo scripts", "url": "https://tanelpoder.com/2013/05/24/list-exadata-disk-layout-and-topology-with-the-exadisktopo-scripts/", "published_at": "2013-05-24T19:42:29+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3a613fd3", "title": "V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells", "url": "https://tanelpoder.com/2013/05/23/vcell_thread_history-ash-for-exadata-storage-cells/", "published_at": "2013-05-23T20:57:33+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3a747ccc", "title": "Understanding what a hint affects using the V$SQL_FEATURE views", "url": "https://tanelpoder.com/2013/04/01/understanding-what-a-hint-affects-using-the-vsql_feature-views/", "published_at": "2013-04-01T17:17:07+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3b728971", "title": "Listing Exadata storage cells and their configuration info from V$CELL_CONFIG", "url": "https://tanelpoder.com/2013/03/21/listing-exadata-storage-cells-and-their-configuration-info-from-vcell_config/", "published_at": "2013-03-21T22:18:47+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3bf5557c", "title": "Alter session force parallel query doesn’t really force anything", "url": "https://tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything/", "published_at": "2013-03-20T16:04:55+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3c97f241", "title": "asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time", "url": "https://tanelpoder.com/2013/03/17/asqlmon-sql-sql-monitoring-like-execution-plan-line-level-drilldown-into-sql-response-time/", "published_at": "2013-03-17T14:23:52+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3cebbbd2", "title": "ExaSnapper 0.7 beta download and the hacking session videos", "url": "https://tanelpoder.com/2013/02/22/exasnapper-0-7-beta-download-and-the-hacking-session-videos/", "published_at": "2013-02-22T19:38:28+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3d89ea87", "title": "Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshooting", "url": "https://tanelpoder.com/2013/02/21/peeking-into-linux-kernel-land-using-proc-filesystem-for-quickndirty-troubleshooting/", "published_at": "2013-02-21T14:46:48+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3db65b91", "title": "Even more Snapper – v4.03 now works in SQL Developer too!", "url": "https://tanelpoder.com/2013/02/18/even-more-snapper-v4-03-now-works-in-sql-developer-too/", "published_at": "2013-02-18T23:21:54+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3e6717e3", "title": "Manual “before” and “after” snapshot support in Snapper v4", "url": "https://tanelpoder.com/2013/02/18/manual-before-and-after-snapshot-support-in-snapper-v4/", "published_at": "2013-02-18T22:10:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3ed97fb8", "title": "Snapper v4.02 and the Snapper launch party video", "url": "https://tanelpoder.com/2013/02/18/snapper-v4-02-and-the-snapper-launch-party-video/", "published_at": "2013-02-18T21:07:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be3fd899c2", "title": "Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session!", "url": "https://tanelpoder.com/2013/02/14/drilling-deep-into-exadata-performance-with-ash-sql-monitoring-and-exadata-snapper-slides-and-a-hacking-session/", "published_at": "2013-02-14T23:04:04+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be40cd7a2e", "title": "Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner!", "url": "https://tanelpoder.com/2013/02/14/troubleshooting-high-cpu-usage-with-poor-mans-stack-profiler-in-a-one-liner/", "published_at": "2013-02-14T21:12:04+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be41900fe1", "title": "Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script!", "url": "https://tanelpoder.com/2013/02/10/session-snapper-v4-the-worlds-most-advanced-oracle-troubleshooting-script/", "published_at": "2013-02-10T17:33:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be424ea02f", "title": "Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)", "url": "https://tanelpoder.com/2013/01/24/sqlplus-is-my-second-home-part-7-downloading-files-via-sqlplus/", "published_at": "2013-01-24T21:17:22+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be42df130c", "title": "Japanese translation of some of my blog articles", "url": "https://tanelpoder.com/2013/01/17/japanese-translation-of-some-of-my-blog-articles/", "published_at": "2013-01-17T22:49:35+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be42fd19dc", "title": "What the heck is the INTERNAL_FUNCTION in execution plan predicate section?", "url": "https://tanelpoder.com/2013/01/16/what-the-heck-is-the-internal_function-in-execution-plan-predicate-section/", "published_at": "2013-01-17T00:40:11+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be43d4e615", "title": "A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax", "url": "https://tanelpoder.com/2012/12/29/a-tip-for-lazy-oracle-users-type-less-with-ansi-date-and-timestamp-sql-syntax/", "published_at": "2012-12-29T19:00:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be448621a0", "title": "Snapper v3.61 released – and more work is in progress!", "url": "https://tanelpoder.com/2012/12/18/snapper-v3-61-released-and-more-work-is-in-progress/", "published_at": "2012-12-19T01:25:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be450f6563", "title": "Select statement generating redo – and lost write detection", "url": "https://tanelpoder.com/2012/10/31/select-statement-generating-redo-and-lost-write-detection/", "published_at": "2012-10-31T12:08:46+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be457732ac", "title": "Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output", "url": "https://tanelpoder.com/2012/09/19/sqlplus-is-my-second-home-part-6-colorizing-sqlplus-and-terminal-output/", "published_at": "2012-09-19T22:39:20+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be462ca942", "title": "Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven)", "url": "https://tanelpoder.com/2012/09/03/optimizer-statistics-driven-direct-path-read-decision-for-full-table-scans-_direct_read_decision_statistics_driven/", "published_at": "2012-09-04T00:30:19+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be465194b5", "title": "The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stability", "url": "https://tanelpoder.com/2012/08/02/the-limitations-of-cursor_sharing-force-and-force_matching_signature-for-sql-plan-stability/", "published_at": "2012-08-03T04:05:39+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be46f066db", "title": "MOATS-like sqlplus “top” utility for RAC", "url": "https://tanelpoder.com/2012/05/13/moats-like-sqlplus-top-utility-for-rac/", "published_at": "2012-05-13T11:42:11+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be471ac434", "title": "Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.”", "url": "https://tanelpoder.com/2012/05/08/oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object/", "published_at": "2012-05-08T19:45:22+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be47673d5b", "title": "Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?!", "url": "https://tanelpoder.com/2012/05/02/advanced-oracle-troubleshooting-guide-part-10-index-unique-scan-doing-multiblock-reads/", "published_at": "2012-05-02T19:42:56+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be479dd9ab", "title": "Where is LOB data stored?", "url": "https://tanelpoder.com/2012/04/22/where-is-lob-data-stored2/", "published_at": "2012-04-22T15:17:31+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be47e44c96", "title": "Exadata Smart Scan predicate offloading and sequence.NEXTVAL", "url": "https://tanelpoder.com/2012/04/13/exadata-smart-scan-predicate-offloading-and-sequence-nextval/", "published_at": "2012-04-13T15:49:19+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4891ebf9", "title": "Create a database link with the new host:port/service syntax", "url": "https://tanelpoder.com/2012/03/05/create-a-database-link-with-the-new-hostportservice-syntax/", "published_at": "2012-03-05T15:57:11+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be490c266b", "title": "Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis", "url": "https://tanelpoder.com/2011/12/22/oracle-core-essential-internals-for-dbas-and-developers-book-by-jonathan-lewis/", "published_at": "2011-12-22T23:48:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be499ef445", "title": "Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking", "url": "https://tanelpoder.com/2011/11/14/profiling-trace-files-with-preprocessor-external-tables-in-11g-and-some-parallel-execution-hacking/", "published_at": "2011-11-14T21:33:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4a20bd85", "title": "Evil things are happening in Oracle", "url": "https://tanelpoder.com/2011/11/13/evil-things-are-happening-in-oracle/", "published_at": "2011-11-13T16:05:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4af4d9ac", "title": "What the heck is the SQL Execution ID – SQL_EXEC_ID?", "url": "https://tanelpoder.com/2011/10/24/what-the-heck-is-the-sql-execution-id-sql_exec_id/", "published_at": "2011-10-24T20:55:29+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4bcf06a4", "title": "V8 Bundled Exec call – and Oracle Program Interface (OPI) calls", "url": "https://tanelpoder.com/2011/08/23/v8-bundled-exec-call-and-oracle-program-interface-opi-calls/", "published_at": "2011-08-23T13:13:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4c0a6fc1", "title": "Full scans, direct path reads and ORA-8103 error hacking session video", "url": "https://tanelpoder.com/2011/08/11/full-scans-direct-path-reads-and-ora-8103-error-hacking-session-video-here-plus-itunes-podcast-address-2/", "published_at": "2011-08-11T17:35:46+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4cc206b8", "title": "Are you getting the most out of your Exadata performance? Part 1", "url": "https://tanelpoder.com/2011/08/08/are-you-getting-the-most-out-of-your-exadata-performance-part-1/", "published_at": "2011-08-08T14:54:42+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4d1811b6", "title": "What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?", "url": "https://tanelpoder.com/2011/07/06/what-is-the-purpose-of-segment-level-checkpoint-before-droptruncate-of-a-table/", "published_at": "2011-07-06T08:52:10+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4d5238ea", "title": "Another cache buffers chains latch contention troubleshooting example using LatchProf", "url": "https://tanelpoder.com/2011/06/30/another-cache-buffers-chains-latch-contention-troubleshooting-example-using-latchprof/", "published_at": "2011-06-30T21:53:34+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4d5776b7", "title": "Tech Reviewer, Tech Reviewer! ;-)", "url": "https://tanelpoder.com/2011/06/29/tech-reviewer-tech-reviewer/", "published_at": "2011-06-29T10:32:49+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4df8999b", "title": "IOUG Select Journal Editor’s Choice Award 2011", "url": "https://tanelpoder.com/2011/06/29/ioug-select-journal-editors-choice-award-2011/", "published_at": "2011-06-29T10:23:18+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4eebcacc", "title": "Knowing what you want to achieve before thinking of how to achieve it – a query optimization example", "url": "https://tanelpoder.com/2011/06/28/knowing-what-you-want-to-achieve-before-thinking-of-how-to-achieve-it-a-query-optimization-example-2/", "published_at": "2011-06-28T23:48:16+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4f793cb5", "title": "Running SELECT … INTO :bind_variable from SQL", "url": "https://tanelpoder.com/2011/04/10/running-select-into-bind_variable-from-sql/", "published_at": "2011-04-10T15:46:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be4fae6b2b", "title": "Latch contention troubleshooting case study and Flashback Database performance issues with LOBs", "url": "https://tanelpoder.com/2011/04/04/latch-contention-troubleshooting-case-study-and-flashback-database-performance-issues-with-lobs/", "published_at": "2011-04-04T13:26:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be50116294", "title": "MOATS: The Mother of All Tuning Scripts!", "url": "https://tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/", "published_at": "2011-03-29T23:23:37+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be50cc446f", "title": "An index of my TPT scripts", "url": "https://tanelpoder.com/2011/03/24/an-index-of-my-tpt-scripts/", "published_at": "2011-03-24T14:10:05+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be50cce546", "title": "LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051)", "url": "https://tanelpoder.com/2011/03/20/lobread-sql-trace-entry-in-oracle-11-2/", "published_at": "2011-03-20T14:52:49+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be51bc195a", "title": "Implicit datatype conversion in the parsing phase – something new I learned today!", "url": "https://tanelpoder.com/2011/03/18/implicit-datatype-conversion-in-the-parsing-phase-something-new-i-learned-today/", "published_at": "2011-03-18T12:25:33+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be51fd73b3", "title": "ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!", "url": "https://tanelpoder.com/2011/03/16/ora-4031-errors-contention-cursor-management-issues-and-shared-pool-fragmentation-free-secret-seminar/", "published_at": "2011-03-16T12:21:50+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be521704b3", "title": "Exadata CAN do smart scans on bitmap indexes", "url": "https://tanelpoder.com/2011/03/15/exadata-can-do-smart-scans-on-bitmap-indexes/", "published_at": "2011-03-15T22:27:43+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be524c5d87", "title": "Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes?", "url": "https://tanelpoder.com/2011/03/13/oracle-exadata-performance-series-part-1-should-i-use-hugepages-on-linux-database-nodes/", "published_at": "2011-03-13T18:54:42+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5288113c", "title": "Finding Oracle Homes which Oracle instances are using on Linux", "url": "https://tanelpoder.com/2011/02/28/finding-oracle-homes-with/", "published_at": "2011-02-28T12:42:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be52edfaed", "title": "New cursor_bind_capture_destination parameter in Oracle 11.2.0.2", "url": "https://tanelpoder.com/2011/01/19/new-cursor_bind_capture_destination-parameter-in-oracle-11-2-0-2/", "published_at": "2011-01-19T23:33:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be535c9239", "title": "Performance Stories from Exadata Migrations", "url": "https://tanelpoder.com/2011/01/11/performance-stories-from-exadata-migrations/", "published_at": "2011-01-12T01:04:47+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be54541ea9", "title": "Is this valid SQL syntax? :-)", "url": "https://tanelpoder.com/2011/01/10/is-this-valid-sql-syntax/", "published_at": "2011-01-10T23:07:56+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be55133cda", "title": "Snapper 3.52 – With Oracle 9.2 support!", "url": "https://tanelpoder.com/2011/01/09/snapper-3-52-with-oracle-9-2-support-2/", "published_at": "2011-01-09T19:28:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be55e2dc61", "title": "Asynch descriptor resize wait event in Oracle", "url": "https://tanelpoder.com/2010/11/23/asynch-descriptor-resize-wait-event-in-oracle/", "published_at": "2010-11-23T21:01:05+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be563de6de", "title": "A little new feature for shared pool geeks :-)", "url": "https://tanelpoder.com/2010/11/04/a-little-new-feature-for-shared-pool-geeks/", "published_at": "2010-11-05T01:22:53+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be56ba7b26", "title": "COUNT STOPKEY operation (the where ROWNUM", "url": "https://tanelpoder.com/2010/10/25/count-stopkey-operation-the-where-rownum/", "published_at": "2010-10-25T17:51:06+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be57194d3c", "title": "Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2", "url": "https://tanelpoder.com/2010/10/18/read-currently-running-sql-statements-bind-variable-values/", "published_at": "2010-10-18T11:11:29+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5743a2dd", "title": "The most fundamental difference between hash and nested loop joins", "url": "https://tanelpoder.com/2010/10/06/a-the-most-fundamental-difference-between-hash-and-nested-loop-joins/", "published_at": "2010-10-06T20:00:23+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be57b5ebfb", "title": "Oracle Closed World presentation links", "url": "https://tanelpoder.com/2010/09/20/oracle-closed-world-presentation-links/", "published_at": "2010-09-20T22:51:15+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be58076ff0", "title": "Which number takes more space in an Oracle row?", "url": "https://tanelpoder.com/2010/09/02/which-number-takes-more-space-in-an-oracle-row/", "published_at": "2010-09-02T13:32:00+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be580fda74", "title": "Exadata v2 Smart Scan Performance Troubleshooting article", "url": "https://tanelpoder.com/2010/07/30/exadata-v2-smart-scan-performance-troubleshooting-article/", "published_at": "2010-07-30T22:18:25+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be58f29162", "title": "Dropping and creating tables in read only tablespaces?!", "url": "https://tanelpoder.com/2010/07/11/dropping-and-creating-tables-in-read-only-tablespaces-what/", "published_at": "2010-07-11T17:09:12+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be59c65867", "title": "The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements", "url": "https://tanelpoder.com/2010/06/23/the-full-power-of-oracles-diagnostic-events-part-2-oradebug-doc-and-11g-improvements/", "published_at": "2010-06-23T11:46:31+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be59f23a8c", "title": "Oracle memory troubleshooting article", "url": "https://tanelpoder.com/2010/05/28/oracle-memory-troubleshooting-article/", "published_at": "2010-05-28T16:37:45+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5a8a6db5", "title": "Flexible Sqlplus command line history with RLWRAP", "url": "https://tanelpoder.com/2010/05/07/flexible-sqlplus-command-line-history-with-rlwrap/", "published_at": "2010-05-07T22:49:26+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5b7958e4", "title": "Execution plan Quiz: Shouldn’t these row sources be the other way around ;-)", "url": "https://tanelpoder.com/2010/04/27/execution-plan-quiz-shouldnt-these-row-sources-be-the-other-way-around/", "published_at": "2010-04-27T18:58:27+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5c3ed609", "title": "Quiz: Explaining index creation", "url": "https://tanelpoder.com/2010/04/23/quiz-explaining-index-creation/", "published_at": "2010-04-23T14:49:02+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5c4faaec", "title": "cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting", "url": "https://tanelpoder.com/2010/04/21/cursor-pin-s-waits-sporadic-cpu-spikes-and-systematic-troubleshooting/", "published_at": "2010-04-21T21:55:09+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5c6b9a66", "title": "KGH: NO ACCESS – Buffer cache inside streams pool too!", "url": "https://tanelpoder.com/2010/04/21/kgh-no-access-buffer-cache-inside-streams-pool-too/", "published_at": "2010-04-21T19:21:44+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5cea61c6", "title": "Non-trivial performance problems", "url": "https://tanelpoder.com/2010/04/03/non-trivial-performance-problems/", "published_at": "2010-04-03T10:07:26+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5dbc8a26", "title": "Calculate SQL_ID and SQL_HASH_VALUE from SQL text", "url": "https://tanelpoder.com/2010/03/31/calculate-sql_id-and-sql_hash_value-from-sql-text/", "published_at": "2010-03-31T17:39:05+00:00" }, { "id": "01a087e9-67f7-7082-b607-53be5e84540f", "title": "Oracle Latch Contention Troubleshooting", "url": "https://tanelpoder.com/2010/03/27/oracle-latch-contention-troubleshooting/", "published_at": "2010-03-28T04:46:08+00:00" } ] posts Claim your blog
Back to tanelpoder
Blog · corpus.blog/blogs/tanelpoder.com/posts

tanelpoder

tanelpoder.com

2015

Oracle Exadata Performance: Latest Improvements and Less Known Featuresoriginal ↗
24 Mar 2015

2014

Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used?original ↗
6 Oct 2014
About index range scans, disk re-reads and how your new car can go 600 miles per hour!original ↗
17 Sept 2014
Combining Bloom Filter Offloading and Storage Indexes on Exadataoriginal ↗
18 May 2014
What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux?original ↗
9 May 2014
Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAILoriginal ↗
26 Mar 2014
Slides of my previous presentationsoriginal ↗
6 Mar 2014
Where does the Exadata storage() predicate come from?original ↗
5 Mar 2014
Oracle X$ tables – Part 1 – Where do they get their data from?original ↗
10 Jan 2014

2013

cell flash cache read hits vs. cell writes to flash cache statistics on Exadataoriginal ↗
4 Dec 2013
Hard Drive Predictive Failures on Linux and Exadataoriginal ↗
29 Nov 2013
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?original ↗
27 Nov 2013
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?original ↗
27 Nov 2013
Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)original ↗
7 Nov 2013
SGA bigger than the amount of HugePages configured (Linux – 11.2.0.3)original ↗
25 Oct 2013
Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately?original ↗
7 Oct 2013
Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sqloriginal ↗
12 Sept 2013
Oracle Performance & Troubleshooting Online Seminars in 2013original ↗
5 Sept 2013
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)original ↗
22 Aug 2013
ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Supportoriginal ↗
19 Aug 2013
Oracle 12c: Scalar Subquery Unnesting transformationoriginal ↗
13 Aug 2013
Oracle Database 12c R1 (12.1.0.1.0) is finally released!original ↗
25 Jun 2013
Getting the Most Out of ASH online seminaroriginal ↗
5 Jun 2013
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production?original ↗
29 May 2013
Debugger Dangers – Part 2original ↗
27 May 2013
List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scriptsoriginal ↗
24 May 2013
List Exadata Disk Layout and Topology with the exadisktopo scriptsoriginal ↗
24 May 2013
V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cellsoriginal ↗
23 May 2013
Understanding what a hint affects using the V$SQL_FEATURE viewsoriginal ↗
1 Apr 2013
Listing Exadata storage cells and their configuration info from V$CELL_CONFIGoriginal ↗
21 Mar 2013
Alter session force parallel query doesn’t really force anythingoriginal ↗
20 Mar 2013
asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response timeoriginal ↗
17 Mar 2013
ExaSnapper 0.7 beta download and the hacking session videosoriginal ↗
22 Feb 2013
Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshootingoriginal ↗
21 Feb 2013
Even more Snapper – v4.03 now works in SQL Developer too!original ↗
18 Feb 2013
Manual “before” and “after” snapshot support in Snapper v4original ↗
18 Feb 2013
Snapper v4.02 and the Snapper launch party videooriginal ↗
18 Feb 2013
Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session!original ↗
14 Feb 2013
Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner!original ↗
14 Feb 2013
Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script!original ↗
10 Feb 2013
Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)original ↗
24 Jan 2013
Japanese translation of some of my blog articlesoriginal ↗
17 Jan 2013
What the heck is the INTERNAL_FUNCTION in execution plan predicate section?original ↗
17 Jan 2013

2012

A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntaxoriginal ↗
29 Dec 2012
Snapper v3.61 released – and more work is in progress!original ↗
19 Dec 2012
Select statement generating redo – and lost write detectionoriginal ↗
31 Oct 2012
Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal outputoriginal ↗
19 Sept 2012
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven)original ↗
4 Sept 2012
The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stabilityoriginal ↗
3 Aug 2012
MOATS-like sqlplus “top” utility for RACoriginal ↗
13 May 2012
Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.”original ↗
8 May 2012
Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?!original ↗
2 May 2012
Where is LOB data stored?original ↗
22 Apr 2012
Exadata Smart Scan predicate offloading and sequence.NEXTVALoriginal ↗
13 Apr 2012
Create a database link with the new host:port/service syntaxoriginal ↗
5 Mar 2012

2011

Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewisoriginal ↗
22 Dec 2011
Profiling trace files with preprocessor external tables in 11g and some parallel execution hackingoriginal ↗
14 Nov 2011
Evil things are happening in Oracleoriginal ↗
13 Nov 2011
What the heck is the SQL Execution ID – SQL_EXEC_ID?original ↗
24 Oct 2011
V8 Bundled Exec call – and Oracle Program Interface (OPI) callsoriginal ↗
23 Aug 2011
Full scans, direct path reads and ORA-8103 error hacking session videooriginal ↗
11 Aug 2011
Are you getting the most out of your Exadata performance? Part 1original ↗
8 Aug 2011
What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?original ↗
6 Jul 2011
Another cache buffers chains latch contention troubleshooting example using LatchProforiginal ↗
30 Jun 2011
Tech Reviewer, Tech Reviewer! ;-)original ↗
29 Jun 2011
IOUG Select Journal Editor’s Choice Award 2011original ↗
29 Jun 2011
Knowing what you want to achieve before thinking of how to achieve it – a query optimization exampleoriginal ↗
28 Jun 2011
Running SELECT … INTO :bind_variable from SQLoriginal ↗
10 Apr 2011
Latch contention troubleshooting case study and Flashback Database performance issues with LOBsoriginal ↗
4 Apr 2011
MOATS: The Mother of All Tuning Scripts!original ↗
29 Mar 2011
An index of my TPT scriptsoriginal ↗
24 Mar 2011
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051)original ↗
20 Mar 2011
Implicit datatype conversion in the parsing phase – something new I learned today!original ↗
18 Mar 2011
ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!original ↗
16 Mar 2011
Exadata CAN do smart scans on bitmap indexesoriginal ↗
15 Mar 2011
Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes?original ↗
13 Mar 2011
Finding Oracle Homes which Oracle instances are using on Linuxoriginal ↗
28 Feb 2011
New cursor_bind_capture_destination parameter in Oracle 11.2.0.2original ↗
19 Jan 2011
Performance Stories from Exadata Migrationsoriginal ↗
12 Jan 2011
Is this valid SQL syntax? :-)original ↗
10 Jan 2011
Snapper 3.52 – With Oracle 9.2 support!original ↗
9 Jan 2011

2010

Asynch descriptor resize wait event in Oracleoriginal ↗
23 Nov 2010
A little new feature for shared pool geeks :-)original ↗
5 Nov 2010
COUNT STOPKEY operation (the where ROWNUMoriginal ↗
25 Oct 2010
Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2original ↗
18 Oct 2010
The most fundamental difference between hash and nested loop joinsoriginal ↗
6 Oct 2010
Oracle Closed World presentation linksoriginal ↗
20 Sept 2010
Which number takes more space in an Oracle row?original ↗
2 Sept 2010
Exadata v2 Smart Scan Performance Troubleshooting articleoriginal ↗
30 Jul 2010
Dropping and creating tables in read only tablespaces?!original ↗
11 Jul 2010
The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvementsoriginal ↗
23 Jun 2010
Oracle memory troubleshooting articleoriginal ↗
28 May 2010
Flexible Sqlplus command line history with RLWRAPoriginal ↗
7 May 2010
Execution plan Quiz: Shouldn’t these row sources be the other way around ;-)original ↗
27 Apr 2010
Quiz: Explaining index creationoriginal ↗
23 Apr 2010
cursor: pin S waits, sporadic CPU spikes and systematic troubleshootingoriginal ↗
21 Apr 2010
KGH: NO ACCESS – Buffer cache inside streams pool too!original ↗
21 Apr 2010
Non-trivial performance problemsoriginal ↗
3 Apr 2010
Calculate SQL_ID and SQL_HASH_VALUE from SQL textoriginal ↗
31 Mar 2010
Oracle Latch Contention Troubleshootingoriginal ↗
28 Mar 2010
Previous Next