| 6. 11. 2024 | Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VM – tanelpoder.com
|
| 23. 9. 2024 | Visualizing Vision Transformer Embedding Vectors as Heatmaps Videos – tanelpoder.com
|
| 21. 9. 2024 | Visualizing and Comparing Embedding Vectors as Heatmaps – tanelpoder.com
|
| 13. 9. 2024 | Tracking, not Tracing, Linux Thread Activity for Complete System Visibility (eBPF Summit) – tanelpoder.com
|
| 31. 7. 2024 | Python Supports Profiling with Perf - How Does It Work? – tanelpoder.com
|
| 10. 7. 2024 | Can a User Process Consume Kernel Mode CPU Without a Syscall? – tanelpoder.com
|
| 22. 6. 2024 | Next Big Thing – tanelpoder.com
|
| 14. 6. 2024 | Syscallargs: List All Linux System Calls With Their Arguments – tanelpoder.com
|
| 7. 6. 2024 | I rage-converted my RTX4090 into an eGPU – tanelpoder.com
|
| 7. 6. 2024 | Oracle Hint Scopes and Join Level Cardinality Hint – tanelpoder.com
|
| 5. 6. 2024 | New Commenting System – tanelpoder.com
|
| 14. 5. 2024 | Almost Summer Sale: All Videos-Only Classes Discounted This Week! – tanelpoder.com
|
| 8. 3. 2024 | Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps – tanelpoder.com
|
| 13. 2. 2024 | Oracle Index Parallel Degree Fix After Parallel Creation or Rebuild – tanelpoder.com
|
| 10. 3. 2023 | New Training Prices Next Week – tanelpoder.com
|
| 25. 9. 2022 | Report Current Oracle Session Wait Chains from GV$SESSION without ASH – tanelpoder.com
|
| 17. 9. 2022 | Advanced Oracle Troubleshooting Guide, Part 13: OStackProf for Linux, Unix & MacOSX Clients – tanelpoder.com
|
| 15. 7. 2022 | Testing Oracle's Use of Optane Persistent Memory, Part 2 - Fast Log File Sync Waits – tanelpoder.com
|
| 28. 4. 2022 | Testing Oracle's Use of Optane Persistent Memory for Low Latency Commits – tanelpoder.com
|
| 17. 3. 2022 | MySQL Now Shows its Thread Names at OS Level for Better Troubleshooting – tanelpoder.com
|
| 17. 3. 2022 | xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2) – tanelpoder.com
|
| 15. 3. 2022 | My New Learning Platform and What I'm Up To in 2022 – tanelpoder.com
|
| 18. 11. 2021 | Achieving 10 GB/s Scanning Rate in a Single Cloud VM – tanelpoder.com
|
| 18. 10. 2021 | Testing The Silk Platform - Hands-On Technical Analysis of High-Performance I/O in the Cloud – tanelpoder.com
|
| 19. 3. 2021 | Virtual Conference: Troubleshooting Very Complex Oracle Performance Problems – tanelpoder.com
|
| 16. 3. 2021 | Do Not Use '>' in Your Command Prompt (and How to Stay Safe in Shell) – tanelpoder.com
|
| 3. 3. 2021 | Video: Troubleshooting Complex Oracle Issues Part 2 – tanelpoder.com
|
| 15. 2. 2021 | Is Your Linux Version Hiding Interrupt CPU Usage From You? – tanelpoder.com
|
| 7. 2. 2021 | Video: High Performance Block I/O on Linux – tanelpoder.com
|
| 29. 1. 2021 | Achieving 11M IOPS & 66 GB/s IO on a Single ThreadRipper Workstation – tanelpoder.com
|
| 13. 1. 2021 | Oracle Wait Event Name vs. Display Name – tanelpoder.com
|
| 9. 12. 2020 | LCBC Working Doc – tanelpoder.com
|
| 28. 11. 2020 | Measuring Java JVM thread activity in Linux with task state sampling – tanelpoder.com
|
| 25. 11. 2020 | Reasons why SELECT * is bad for SQL performance – tanelpoder.com
|
| 20. 11. 2020 | High System Load with Low CPU Utilization on Linux? – tanelpoder.com
|
| 21. 5. 2020 | Hacking Session: 7 Levels of Hint Invalidity in Oracle SQL – tanelpoder.com
|
| 8. 5. 2020 | Hacking Session: Oracle SQL Monitoring - Understanding the Execution Timeline column and CPU usage – tanelpoder.com
|
| 8. 4. 2020 | Virtual Conference: Systematic Oracle SQL Optimization Interview Videos – tanelpoder.com
|
| 24. 3. 2020 | Oracle Fatal Background Processes – tanelpoder.com
|
| 23. 3. 2020 | Virtual Conference Update: Systematic Oracle SQL Optimization in 2020 – tanelpoder.com
|
| 4. 3. 2020 | Oracle Shared Pool Internals: List Chunk Position in the LRU List – tanelpoder.com
|
| 27. 2. 2020 | SchedLat: a Low Tech Script for Measuring Process CPU Scheduling Latency on Linux – tanelpoder.com
|
| 19. 2. 2020 | Announcing My Retirement (in 2030)! – tanelpoder.com
|
| 12. 2. 2020 | ORA-12850: Could not allocate slaves on all specified instances error and a workaround for my scripts – tanelpoder.com
|
| 11. 2. 2020 | Oracle Performance Troubleshooting Without OS Access, Part 1: Identifying CPU Scheduling Latency – tanelpoder.com
|
| 3. 2. 2020 | Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020) – tanelpoder.com
|
| 30. 1. 2020 | Hacking Session: Troubleshooting Complex Oracle Performance Problems (January 2020) – tanelpoder.com
|
| 15. 1. 2020 | help.sql: Show TPT Script Purpose and Syntax – tanelpoder.com
|
| 15. 1. 2020 | help.sql: Show TPT Script Purpose and Syntax – tanelpoder.com
|
| 9. 1. 2020 | Oracle State Objects and Reading System State Dumps Hacking Session Video – tanelpoder.com
|
| 9. 1. 2020 | Oracle State Objects and Reading System State Dumps Hacking Session Video – tanelpoder.com
|
| 4. 10. 2019 | New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1) – tanelpoder.com
|
| 4. 10. 2019 | New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1) – tanelpoder.com
|
| 18. 9. 2019 | Traveling, Speaking, Training, Gluent and What I'm Up To (2019) – tanelpoder.com
|
| 18. 9. 2019 | Traveling, Speaking, Training, Gluent and What I'm Up To (2019) – tanelpoder.com
|
| 9. 4. 2019 | Get a 20% discount when signing up for two training classes in 2019! – tanelpoder.com
|
| 8. 4. 2019 | Dump Current Oracle SQL Execution Plan Line ID Using Oradebug – tanelpoder.com
|
| 8. 4. 2019 | Dump Current Oracle SQL Execution Plan Line ID Using Oradebug – tanelpoder.com
|
| 3. 4. 2019 | pSnapper: Linux Process Snapper Page and Videos – tanelpoder.com
|
| 3. 4. 2019 | pSnapper: Linux Process Snapper Page and Videos – tanelpoder.com
|
| 1. 4. 2019 | Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT) – tanelpoder.com
|
| 1. 4. 2019 | Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT) – tanelpoder.com
|
| 29. 3. 2019 | What Caused This Wait Event: Using Oracle's wait_event[] tracing – tanelpoder.com
|
| 29. 3. 2019 | What Caused This Wait Event: Using Oracle's wait_event[] tracing – tanelpoder.com
|
| 7. 3. 2019 | Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds? – tanelpoder.com
|
| 7. 3. 2019 | Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds? – tanelpoder.com
|
| 4. 3. 2019 | Practical Linux Performance & Application Troubleshooting Training Details and Table of Contents – tanelpoder.com
|
| 4. 3. 2019 | Practical Linux Performance & Application Troubleshooting Training Details and Table of Contents – tanelpoder.com
|
| 9. 11. 2018 | Scripts for Drilling Down Into Unknown Optimizer Changes – tanelpoder.com
|
| 9. 11. 2018 | Scripts for Drilling Down Into Unknown Optimizer Changes – tanelpoder.com
|
| 28. 10. 2018 | Visualizing SQL Plan Execution Time With FlameGraphs – tanelpoder.com
|
| 28. 10. 2018 | Visualizing SQL Plan Execution Time With FlameGraphs – tanelpoder.com
|
| 10. 10. 2018 | Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed) – tanelpoder.com
|
| 10. 10. 2018 | Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed) – tanelpoder.com
|
| 8. 10. 2018 | Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progress – tanelpoder.com
|
| 8. 10. 2018 | Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progress – tanelpoder.com
|
| 29. 8. 2018 | Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions! – tanelpoder.com
|
| 29. 8. 2018 | Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions! – tanelpoder.com
|
| 20. 8. 2018 | Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too! – tanelpoder.com
|
| 20. 8. 2018 | Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too! – tanelpoder.com
|
| 7. 6. 2018 | Webinar: Troubleshooting a Complex Oracle Performance Issue – tanelpoder.com
|
| 7. 6. 2018 | Webinar: Troubleshooting a Complex Oracle Performance Issue – tanelpoder.com
|
| 18. 5. 2018 | My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced – tanelpoder.com
|
| 18. 5. 2018 | My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced – tanelpoder.com
|
| 25. 1. 2018 | Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication – tanelpoder.com
|
| 25. 1. 2018 | Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication – tanelpoder.com
|
| 11. 1. 2018 | Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too – tanelpoder.com
|
| 11. 1. 2018 | Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too – tanelpoder.com
|
| 29. 11. 2017 | Advanced Oracle Troubleshooting seminar in 2018! – tanelpoder.com
|
| 29. 11. 2017 | Advanced Oracle Troubleshooting seminar in 2018! – tanelpoder.com
|
| 11. 7. 2017 | Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month – tanelpoder.com
|
| 11. 7. 2017 | Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month – tanelpoder.com
|
| 28. 3. 2016 | GNW01: In-Memory Processing for Databases – tanelpoder.com
|
| 28. 3. 2016 | GNW01: In-Memory Processing for Databases – tanelpoder.com
|
| 27. 1. 2016 | My BIWA Summit Presentations – tanelpoder.com
|
| 27. 1. 2016 | My BIWA Summit Presentations – tanelpoder.com
|
| 30. 11. 2015 | RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cycles – tanelpoder.com
|
| 30. 11. 2015 | RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cycles – tanelpoder.com
|
| 24. 11. 2015 | My New Youtube Channel – tanelpoder.com
|
| 24. 11. 2015 | My New Youtube Channel – tanelpoder.com
|
| 11. 11. 2015 | Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention – tanelpoder.com
|
| 11. 11. 2015 | Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention – tanelpoder.com
|
| 29. 10. 2015 | SQL Monitoring in Oracle Database 12c – tanelpoder.com
|
| 29. 10. 2015 | SQL Monitoring in Oracle Database 12c – tanelpoder.com
|
| 28. 10. 2015 | Connecting Hadoop and Oracle – tanelpoder.com
|
| 28. 10. 2015 | Connecting Hadoop and Oracle – tanelpoder.com
|
| 9. 10. 2015 | Advanced Oracle Troubleshooting v2.5 (with 12c stuff too) – tanelpoder.com
|
| 9. 10. 2015 | Advanced Oracle Troubleshooting v2.5 (with 12c stuff too) – tanelpoder.com
|
| 21. 9. 2015 | RAM is the new disk – and how to measure its performance – Part 2 – Tools – tanelpoder.com
|
| 21. 9. 2015 | RAM is the new disk – and how to measure its performance – Part 2 – Tools – tanelpoder.com
|
| 10. 8. 2015 | RAM is the new disk – and how to measure its performance – Part 1 – Introduction – tanelpoder.com
|
| 10. 8. 2015 | RAM is the new disk – and how to measure its performance – Part 1 – Introduction – tanelpoder.com
|
| 30. 6. 2015 | The Hybrid World is Coming – tanelpoder.com
|
| 30. 6. 2015 | The Hybrid World is Coming – tanelpoder.com
|
| 19. 6. 2015 | Old ventures and new adventures – tanelpoder.com
|
| 19. 6. 2015 | Old ventures and new adventures – tanelpoder.com
|
| 25. 4. 2015 | Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits? – tanelpoder.com
|
| 25. 4. 2015 | Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits? – tanelpoder.com
|
| 29. 3. 2015 | Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable – tanelpoder.com
|
| 29. 3. 2015 | Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable – tanelpoder.com
|
| 24. 3. 2015 | Oracle Exadata Performance: Latest Improvements and Less Known Features – tanelpoder.com
|
| 24. 3. 2015 | Oracle Exadata Performance: Latest Improvements and Less Known Features – tanelpoder.com
|
| 6. 10. 2014 | Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used? – tanelpoder.com
|
| 6. 10. 2014 | Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used? – tanelpoder.com
|
| 17. 9. 2014 | About index range scans, disk re-reads and how your new car can go 600 miles per hour! – tanelpoder.com
|
| 17. 9. 2014 | About index range scans, disk re-reads and how your new car can go 600 miles per hour! – tanelpoder.com
|
| 18. 5. 2014 | Combining Bloom Filter Offloading and Storage Indexes on Exadata – tanelpoder.com
|
| 18. 5. 2014 | Combining Bloom Filter Offloading and Storage Indexes on Exadata – tanelpoder.com
|
| 9. 5. 2014 | What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux? – tanelpoder.com
|
| 9. 5. 2014 | What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux? – tanelpoder.com
|
| 26. 3. 2014 | Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL – tanelpoder.com
|
| 26. 3. 2014 | Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL – tanelpoder.com
|
| 6. 3. 2014 | Slides of my previous presentations – tanelpoder.com
|
| 6. 3. 2014 | Slides of my previous presentations – tanelpoder.com
|
| 5. 3. 2014 | Where does the Exadata storage() predicate come from? – tanelpoder.com
|
| 5. 3. 2014 | Where does the Exadata storage() predicate come from? – tanelpoder.com
|
| 10. 1. 2014 | Oracle X$ tables – Part 1 – Where do they get their data from? – tanelpoder.com
|
| 10. 1. 2014 | Oracle X$ tables – Part 1 – Where do they get their data from? – tanelpoder.com
|
| 4. 12. 2013 | cell flash cache read hits vs. cell writes to flash cache statistics on Exadata – tanelpoder.com
|
| 4. 12. 2013 | cell flash cache read hits vs. cell writes to flash cache statistics on Exadata – tanelpoder.com
|
| 29. 11. 2013 | Hard Drive Predictive Failures on Linux and Exadata – tanelpoder.com
|
| 29. 11. 2013 | Hard Drive Predictive Failures on Linux and Exadata – tanelpoder.com
|
| 27. 11. 2013 | When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2? – tanelpoder.com
|
| 27. 11. 2013 | When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2? – tanelpoder.com
|
| 27. 11. 2013 | When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1? – tanelpoder.com
|
| 27. 11. 2013 | When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1? – tanelpoder.com
|
| 7. 11. 2013 | Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2) – tanelpoder.com
|
| 7. 11. 2013 | Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2) – tanelpoder.com
|
| 25. 10. 2013 | SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3) – tanelpoder.com
|
| 25. 10. 2013 | SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3) – tanelpoder.com
|
| 7. 10. 2013 | Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately? – tanelpoder.com
|
| 7. 10. 2013 | Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately? – tanelpoder.com
|
| 12. 9. 2013 | Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql – tanelpoder.com
|
| 12. 9. 2013 | Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql – tanelpoder.com
|
| 5. 9. 2013 | Oracle Performance & Troubleshooting Online Seminars in 2013 – tanelpoder.com
|
| 5. 9. 2013 | Oracle Performance & Troubleshooting Online Seminars in 2013 – tanelpoder.com
|
| 22. 8. 2013 | Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too) – tanelpoder.com
|
| 22. 8. 2013 | Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too) – tanelpoder.com
|
| 19. 8. 2013 | ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support – tanelpoder.com
|
| 19. 8. 2013 | ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support – tanelpoder.com
|
| 13. 8. 2013 | Oracle 12c: Scalar Subquery Unnesting transformation – tanelpoder.com
|
| 13. 8. 2013 | Oracle 12c: Scalar Subquery Unnesting transformation – tanelpoder.com
|
| 25. 6. 2013 | Oracle Database 12c R1 (12.1.0.1.0) is finally released! – tanelpoder.com
|
| 25. 6. 2013 | Oracle Database 12c R1 (12.1.0.1.0) is finally released! – tanelpoder.com
|
| 5. 6. 2013 | Getting the Most Out of ASH online seminar – tanelpoder.com
|
| 5. 6. 2013 | Getting the Most Out of ASH online seminar – tanelpoder.com
|
| 29. 5. 2013 | Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? – tanelpoder.com
|
| 29. 5. 2013 | Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? – tanelpoder.com
|
| 27. 5. 2013 | Debugger Dangers – Part 2 – tanelpoder.com
|
| 27. 5. 2013 | Debugger Dangers – Part 2 – tanelpoder.com
|
| 24. 5. 2013 | List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts – tanelpoder.com
|
| 24. 5. 2013 | List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts – tanelpoder.com
|
| 24. 5. 2013 | List Exadata Disk Layout and Topology with the exadisktopo scripts – tanelpoder.com
|
| 24. 5. 2013 | List Exadata Disk Layout and Topology with the exadisktopo scripts – tanelpoder.com
|
| 23. 5. 2013 | V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells – tanelpoder.com
|
| 23. 5. 2013 | V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells – tanelpoder.com
|
| 1. 4. 2013 | Understanding what a hint affects using the V$SQL_FEATURE views – tanelpoder.com
|
| 1. 4. 2013 | Understanding what a hint affects using the V$SQL_FEATURE views – tanelpoder.com
|
| 21. 3. 2013 | Listing Exadata storage cells and their configuration info from V$CELL_CONFIG – tanelpoder.com
|
| 21. 3. 2013 | Listing Exadata storage cells and their configuration info from V$CELL_CONFIG – tanelpoder.com
|
| 20. 3. 2013 | Alter session force parallel query doesn’t really force anything – tanelpoder.com
|
| 20. 3. 2013 | Alter session force parallel query doesn’t really force anything – tanelpoder.com
|
| 17. 3. 2013 | asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time – tanelpoder.com
|
| 17. 3. 2013 | asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time – tanelpoder.com
|
| 22. 2. 2013 | ExaSnapper 0.7 beta download and the hacking session videos – tanelpoder.com
|
| 22. 2. 2013 | ExaSnapper 0.7 beta download and the hacking session videos – tanelpoder.com
|
| 21. 2. 2013 | Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshooting – tanelpoder.com
|
| 21. 2. 2013 | Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshooting – tanelpoder.com
|
| 19. 2. 2013 | Even more Snapper – v4.03 now works in SQL Developer too! – tanelpoder.com
|
| 19. 2. 2013 | Even more Snapper – v4.03 now works in SQL Developer too! – tanelpoder.com
|
| 18. 2. 2013 | Manual “before” and “after” snapshot support in Snapper v4 – tanelpoder.com
|
| 18. 2. 2013 | Manual “before” and “after” snapshot support in Snapper v4 – tanelpoder.com
|
| 18. 2. 2013 | Snapper v4.02 and the Snapper launch party video – tanelpoder.com
|
| 18. 2. 2013 | Snapper v4.02 and the Snapper launch party video – tanelpoder.com
|
| 15. 2. 2013 | Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session! – tanelpoder.com
|
| 15. 2. 2013 | Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session! – tanelpoder.com
|
| 14. 2. 2013 | Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner! – tanelpoder.com
|
| 14. 2. 2013 | Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner! – tanelpoder.com
|
| 10. 2. 2013 | Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script! – tanelpoder.com
|
| 10. 2. 2013 | Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script! – tanelpoder.com
|
| 24. 1. 2013 | Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-) – tanelpoder.com
|
| 24. 1. 2013 | Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-) – tanelpoder.com
|
| 17. 1. 2013 | Japanese translation of some of my blog articles – tanelpoder.com
|
| 17. 1. 2013 | Japanese translation of some of my blog articles – tanelpoder.com
|
| 17. 1. 2013 | What the heck is the INTERNAL_FUNCTION in execution plan predicate section? – tanelpoder.com
|
| 17. 1. 2013 | What the heck is the INTERNAL_FUNCTION in execution plan predicate section? – tanelpoder.com
|
| 29. 12. 2012 | A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax – tanelpoder.com
|
| 29. 12. 2012 | A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax – tanelpoder.com
|
| 19. 12. 2012 | Snapper v3.61 released – and more work is in progress! – tanelpoder.com
|
| 19. 12. 2012 | Snapper v3.61 released – and more work is in progress! – tanelpoder.com
|
| 31. 10. 2012 | Select statement generating redo – and lost write detection – tanelpoder.com
|
| 31. 10. 2012 | Select statement generating redo – and lost write detection – tanelpoder.com
|
| 20. 9. 2012 | Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output – tanelpoder.com
|
| 20. 9. 2012 | Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output – tanelpoder.com
|
| 4. 9. 2012 | Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) – tanelpoder.com
|
| 4. 9. 2012 | Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) – tanelpoder.com
|
| 3. 8. 2012 | The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stability – tanelpoder.com
|
| 3. 8. 2012 | The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stability – tanelpoder.com
|
| 13. 5. 2012 | MOATS-like sqlplus “top” utility for RAC – tanelpoder.com
|
| 13. 5. 2012 | MOATS-like sqlplus “top” utility for RAC – tanelpoder.com
|
| 8. 5. 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.” – tanelpoder.com
|
| 8. 5. 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.” – tanelpoder.com
|
| 2. 5. 2012 | Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?! – tanelpoder.com
|
| 2. 5. 2012 | Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?! – tanelpoder.com
|
| 22. 4. 2012 | Where is LOB data stored? – tanelpoder.com
|
| 22. 4. 2012 | Where is LOB data stored? – tanelpoder.com
|
| 22. 4. 2012 | Where is LOB data stored? – tanelpoder.com
|
| 13. 4. 2012 | Exadata Smart Scan predicate offloading and sequence.NEXTVAL – tanelpoder.com
|
| 13. 4. 2012 | Exadata Smart Scan predicate offloading and sequence.NEXTVAL – tanelpoder.com
|
| 5. 3. 2012 | Create a database link with the new host:port/service syntax – tanelpoder.com
|
| 5. 3. 2012 | Create a database link with the new host:port/service syntax – tanelpoder.com
|
| 23. 12. 2011 | Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis – tanelpoder.com
|
| 23. 12. 2011 | Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis – tanelpoder.com
|
| 14. 11. 2011 | Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking – tanelpoder.com
|
| 14. 11. 2011 | Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking – tanelpoder.com
|
| 13. 11. 2011 | Evil things are happening in Oracle – tanelpoder.com
|
| 13. 11. 2011 | Evil things are happening in Oracle – tanelpoder.com
|
| 24. 10. 2011 | What the heck is the SQL Execution ID – SQL_EXEC_ID? – tanelpoder.com
|
| 24. 10. 2011 | What the heck is the SQL Execution ID – SQL_EXEC_ID? – tanelpoder.com
|
| 23. 8. 2011 | V8 Bundled Exec call – and Oracle Program Interface (OPI) calls – tanelpoder.com
|
| 23. 8. 2011 | V8 Bundled Exec call – and Oracle Program Interface (OPI) calls – tanelpoder.com
|
| 11. 8. 2011 | Full scans, direct path reads and ORA-8103 error hacking session video – tanelpoder.com
|
| 11. 8. 2011 | Full scans, direct path reads and ORA-8103 error hacking session video – tanelpoder.com
|
| 8. 8. 2011 | Are you getting the most out of your Exadata performance? Part 1 – tanelpoder.com
|
| 8. 8. 2011 | Are you getting the most out of your Exadata performance? Part 1 – tanelpoder.com
|
| 6. 7. 2011 | What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? – tanelpoder.com
|
| 6. 7. 2011 | What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? – tanelpoder.com
|
| 30. 6. 2011 | Another cache buffers chains latch contention troubleshooting example using LatchProf – tanelpoder.com
|
| 30. 6. 2011 | Another cache buffers chains latch contention troubleshooting example using LatchProf – tanelpoder.com
|
| 29. 6. 2011 | Tech Reviewer, Tech Reviewer! ;-) – tanelpoder.com
|
| 29. 6. 2011 | Tech Reviewer, Tech Reviewer! ;-) – tanelpoder.com
|
| 29. 6. 2011 | IOUG Select Journal Editor’s Choice Award 2011 – tanelpoder.com
|
| 29. 6. 2011 | IOUG Select Journal Editor’s Choice Award 2011 – tanelpoder.com
|
| 29. 6. 2011 | Knowing what you want to achieve before thinking of how to achieve it – a query optimization example – tanelpoder.com
|
| 29. 6. 2011 | Knowing what you want to achieve before thinking of how to achieve it – a query optimization example – tanelpoder.com
|
| 10. 4. 2011 | Running SELECT … INTO :bind_variable from SQL – tanelpoder.com
|
| 10. 4. 2011 | Running SELECT … INTO :bind_variable from SQL – tanelpoder.com
|
| 4. 4. 2011 | Latch contention troubleshooting case study and Flashback Database performance issues with LOBs – tanelpoder.com
|
| 4. 4. 2011 | Latch contention troubleshooting case study and Flashback Database performance issues with LOBs – tanelpoder.com
|
| 30. 3. 2011 | MOATS: The Mother of All Tuning Scripts! – tanelpoder.com
|
| 30. 3. 2011 | MOATS: The Mother of All Tuning Scripts! – tanelpoder.com
|
| 24. 3. 2011 | An index of my TPT scripts – tanelpoder.com
|
| 24. 3. 2011 | An index of my TPT scripts – tanelpoder.com
|
| 20. 3. 2011 | LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051) – tanelpoder.com
|
| 20. 3. 2011 | LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051) – tanelpoder.com
|
| 18. 3. 2011 | Implicit datatype conversion in the parsing phase – something new I learned today! – tanelpoder.com
|
| 18. 3. 2011 | Implicit datatype conversion in the parsing phase – something new I learned today! – tanelpoder.com
|
| 16. 3. 2011 | ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar! – tanelpoder.com
|
| 16. 3. 2011 | ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar! – tanelpoder.com
|
| 15. 3. 2011 | Exadata CAN do smart scans on bitmap indexes – tanelpoder.com
|
| 15. 3. 2011 | Exadata CAN do smart scans on bitmap indexes – tanelpoder.com
|
| 13. 3. 2011 | Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes? – tanelpoder.com
|
| 13. 3. 2011 | Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes? – tanelpoder.com
|
| 28. 2. 2011 | Finding Oracle Homes which Oracle instances are using on Linux – tanelpoder.com
|
| 28. 2. 2011 | Finding Oracle Homes which Oracle instances are using on Linux – tanelpoder.com
|
| 20. 1. 2011 | New cursor_bind_capture_destination parameter in Oracle 11.2.0.2 – tanelpoder.com
|
| 20. 1. 2011 | New cursor_bind_capture_destination parameter in Oracle 11.2.0.2 – tanelpoder.com
|
| 12. 1. 2011 | Performance Stories from Exadata Migrations – tanelpoder.com
|
| 12. 1. 2011 | Performance Stories from Exadata Migrations – tanelpoder.com
|
| 11. 1. 2011 | Is this valid SQL syntax? :-) – tanelpoder.com
|
| 11. 1. 2011 | Is this valid SQL syntax? :-) – tanelpoder.com
|
| 9. 1. 2011 | Snapper 3.52 – With Oracle 9.2 support! – tanelpoder.com
|
| 9. 1. 2011 | Snapper 3.52 – With Oracle 9.2 support! – tanelpoder.com
|
| 23. 11. 2010 | Asynch descriptor resize wait event in Oracle – tanelpoder.com
|
| 23. 11. 2010 | Asynch descriptor resize wait event in Oracle – tanelpoder.com
|
| 5. 11. 2010 | A little new feature for shared pool geeks :-) – tanelpoder.com
|
| 5. 11. 2010 | A little new feature for shared pool geeks :-) – tanelpoder.com
|
| 25. 10. 2010 | COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results – tanelpoder.com
|
| 25. 10. 2010 | COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results – tanelpoder.com
|
| 18. 10. 2010 | Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2 – tanelpoder.com
|
| 18. 10. 2010 | Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2 – tanelpoder.com
|
| 6. 10. 2010 | The most fundamental difference between hash and nested loop joins – tanelpoder.com
|
| 6. 10. 2010 | A: The most fundamental difference between hash and nested loop joins – tanelpoder.com
|
| 28. 9. 2010 | Q: The most fundamental difference between HASH and NESTED LOOP joins? – tanelpoder.com
|
| 21. 9. 2010 | Oracle Closed World presentation links – tanelpoder.com
|
| 21. 9. 2010 | Oracle Closed World presentation links – tanelpoder.com
|
| 2. 9. 2010 | Which number takes more space in an Oracle row? – tanelpoder.com
|
| 2. 9. 2010 | Which number takes more space in an Oracle row? – tanelpoder.com
|
| 31. 7. 2010 | Exadata v2 Smart Scan Performance Troubleshooting article – tanelpoder.com
|
| 31. 7. 2010 | Exadata v2 Smart Scan Performance Troubleshooting article – tanelpoder.com
|
| 11. 7. 2010 | Dropping and creating tables in read only tablespaces?! – tanelpoder.com
|
| 11. 7. 2010 | Dropping and creating tables in read only tablespaces?! – tanelpoder.com
|
| 23. 6. 2010 | The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements – tanelpoder.com
|
| 23. 6. 2010 | The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements – tanelpoder.com
|
| 28. 5. 2010 | Oracle memory troubleshooting article – tanelpoder.com
|
| 28. 5. 2010 | Oracle memory troubleshooting article – tanelpoder.com
|
| 8. 5. 2010 | Flexible Sqlplus command line history with RLWRAP – tanelpoder.com
|
| 8. 5. 2010 | Flexible Sqlplus command line history with RLWRAP – tanelpoder.com
|
| 27. 4. 2010 | Execution plan Quiz: Shouldn’t these row sources be the other way around ;-) – tanelpoder.com
|
| 27. 4. 2010 | Execution plan Quiz: Shouldn’t these row sources be the other way around ;-) – tanelpoder.com
|
| 23. 4. 2010 | Quiz: Explaining index creation – tanelpoder.com
|
| 23. 4. 2010 | Quiz: Explaining index creation – tanelpoder.com
|
| 21. 4. 2010 | cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting – tanelpoder.com
|
| 21. 4. 2010 | cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting – tanelpoder.com
|
| 21. 4. 2010 | KGH: NO ACCESS – Buffer cache inside streams pool too! – tanelpoder.com
|
| 21. 4. 2010 | KGH: NO ACCESS – Buffer cache inside streams pool too! – tanelpoder.com
|
| 3. 4. 2010 | Non-trivial performance problems – tanelpoder.com
|
| 3. 4. 2010 | Non-trivial performance problems – tanelpoder.com
|
| 31. 3. 2010 | Calculate SQL_ID and SQL_HASH_VALUE from SQL text – tanelpoder.com
|
| 31. 3. 2010 | Calculate SQL_ID and SQL_HASH_VALUE from SQL text – tanelpoder.com
|
| 28. 3. 2010 | Oracle Latch Contention Troubleshooting – tanelpoder.com
|
| 28. 3. 2010 | Oracle Latch Contention Troubleshooting – tanelpoder.com
|
| 22. 3. 2010 | Oracle Session Snapper v3.10 – tanelpoder.com
|
| 22. 3. 2010 | Oracle Session Snapper v3.10 – tanelpoder.com
|
| 18. 2. 2010 | How to CANCEL a query running in another session? – tanelpoder.com
|
| 18. 2. 2010 | How to CANCEL a query running in another session? – tanelpoder.com
|
| 16. 2. 2010 | New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning – tanelpoder.com
|
| 16. 2. 2010 | New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning – tanelpoder.com
|
| 14. 2. 2010 | Oracle Troubleshooting: How to read Oracle ERRORSTACK output?! – tanelpoder.com
|
| 14. 2. 2010 | Oracle Troubleshooting: How to read Oracle ERRORSTACK output?! – tanelpoder.com
|
| 11. 2. 2010 | Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris – tanelpoder.com
|
| 11. 2. 2010 | Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris – tanelpoder.com
|
| 9. 2. 2010 | Oracle Wait Event reference – tanelpoder.com
|
| 9. 2. 2010 | Oracle Wait Event reference – tanelpoder.com
|
| 3. 2. 2010 | Oracle Peformance Visualization… – tanelpoder.com
|
| 3. 2. 2010 | Oracle Peformance Visualization… – tanelpoder.com
|
| 2. 2. 2010 | Bind Variable Peeking – execution plan inefficiency – tanelpoder.com
|
| 2. 2. 2010 | Bind Variable Peeking – execution plan inefficiency – tanelpoder.com
|
| 22. 1. 2010 | Recursive sessions… – tanelpoder.com
|
| 22. 1. 2010 | Recursive sessions… – tanelpoder.com
|
| 18. 1. 2010 | Sometimes things are easy (Part 1): How to fix wrapped execution plan text? – tanelpoder.com
|
| 18. 1. 2010 | Sometimes things are easy (Part 1): How to fix wrapped execution plan text? – tanelpoder.com
|
| 15. 1. 2010 | Beyond Oracle Wait Interface – Part 2 – tanelpoder.com
|
| 15. 1. 2010 | Beyond Oracle Wait Interface – Part 2 – tanelpoder.com
|
| 30. 12. 2009 | NULL is not zero! – tanelpoder.com
|
| 30. 12. 2009 | NULL is not zero! – tanelpoder.com
|
| 23. 12. 2009 | Measuring what matters – tanelpoder.com
|
| 23. 12. 2009 | Measuring what matters – tanelpoder.com
|
| 19. 11. 2009 | Finding the reasons for excessive logical IOs – tanelpoder.com
|
| 19. 11. 2009 | Finding the reasons for excessive logical IOs – tanelpoder.com
|
| 18. 11. 2009 | Explain Plan For command may show you the wrong execution plan – Part 1 – tanelpoder.com
|
| 18. 11. 2009 | Explain Plan For command may show you the wrong execution plan – Part 1 – tanelpoder.com
|
| 4. 11. 2009 | Detect chained and migrated rows in Oracle – Part 1 – tanelpoder.com
|
| 4. 11. 2009 | Detect chained and migrated rows in Oracle – Part 1 – tanelpoder.com
|
| 26. 10. 2009 | What’s a good way to learn some Oracle internals every day? – tanelpoder.com
|
| 26. 10. 2009 | What’s a good way to learn some Oracle internals every day? – tanelpoder.com
|
| 25. 10. 2009 | SystemTap is production supported in Redhat EL5.4 – tanelpoder.com
|
| 25. 10. 2009 | SystemTap is production supported in Redhat EL5.4 – tanelpoder.com
|
| 14. 9. 2009 | KGL simulator, shared pool simulator and buffer cache simulator – what are these? – tanelpoder.com
|
| 14. 9. 2009 | KGL simulator, shared pool simulator and buffer cache simulator – what are these? – tanelpoder.com
|
| 9. 9. 2009 | KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool! – tanelpoder.com
|
| 9. 9. 2009 | KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool! – tanelpoder.com
|
| 1. 9. 2009 | Oracle 11gR2 has been released – and with column oriented storage option – tanelpoder.com
|
| 1. 9. 2009 | Oracle 11gR2 has been released – and with column oriented storage option – tanelpoder.com
|
| 27. 8. 2009 | latch: cache buffers chains latch contention – a better way for finding the hot block – tanelpoder.com
|
| 27. 8. 2009 | latch: cache buffers chains latch contention – a better way for finding the hot block – tanelpoder.com
|
| 22. 8. 2009 | Select COUNT(*) and COUNT(column) are different things! – tanelpoder.com
|
| 22. 8. 2009 | Select COUNT(*) and COUNT(column) are different things! – tanelpoder.com
|
| 13. 8. 2009 | Alter system kill session and ORA-00031: session marked for kill – tanelpoder.com
|
| 13. 8. 2009 | Alter system kill session and ORA-00031: session marked for kill – tanelpoder.com
|
| 10. 8. 2009 | An interview with me – tanelpoder.com
|
| 10. 8. 2009 | An interview with me – tanelpoder.com
|
| 9. 7. 2009 | How to detect when a cursor was closed from SQL trace output? – tanelpoder.com
|
| 9. 7. 2009 | How to detect when a cursor was closed from SQL trace output? – tanelpoder.com
|
| 9. 7. 2009 | Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile – tanelpoder.com
|
| 9. 7. 2009 | Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile – tanelpoder.com
|
| 27. 6. 2009 | (Secret) Preview of Oracle 12g CBO leaked from Oracle labs… – tanelpoder.com
|
| 27. 6. 2009 | (Secret) Preview of Oracle 12g CBO leaked from Oracle labs… – tanelpoder.com
|
| 24. 6. 2009 | Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump – tanelpoder.com
|
| 24. 6. 2009 | Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump – tanelpoder.com
|
| 10. 6. 2009 | Using Perfsheet and TPT scripts for solving real life performance problems – tanelpoder.com
|
| 10. 6. 2009 | Using Perfsheet and TPT scripts for solving real life performance problems – tanelpoder.com
|
| 5. 6. 2009 | ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql – tanelpoder.com
|
| 5. 6. 2009 | ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql – tanelpoder.com
|
| 27. 5. 2009 | Oracle Performance Visualization videos from Sydney – tanelpoder.com
|
| 27. 5. 2009 | Oracle Performance Visualization videos from Sydney – tanelpoder.com
|
| 26. 5. 2009 | Scripts for showing execution plans via plain SQL and also in Oracle 9i – tanelpoder.com
|
| 26. 5. 2009 | Scripts for showing execution plans via plain SQL and also in Oracle 9i – tanelpoder.com
|
| 6. 5. 2009 | “Free” DBA_HIST AWR views in 11g… – tanelpoder.com
|
| 6. 5. 2009 | “Free” DBA_HIST AWR views in 11g… – tanelpoder.com
|
| 1. 5. 2009 | I have been troubleshooting since I was a kid! :) – tanelpoder.com
|
| 1. 5. 2009 | I have been troubleshooting since I was a kid! :) – tanelpoder.com
|
| 24. 4. 2009 | Tracing Oracle SQL plan execution with DTrace – tanelpoder.com
|
| 24. 4. 2009 | Tracing Oracle SQL plan execution with DTrace – tanelpoder.com
|
| 20. 4. 2009 | Seminar feedback and pictures from Singapore – tanelpoder.com
|
| 20. 4. 2009 | Seminar feedback and pictures from Singapore – tanelpoder.com
|
| 27. 3. 2009 | Read OS environment variables using DBMS_SYSTEM.GET_ENV() – tanelpoder.com
|
| 27. 3. 2009 | Read OS environment variables using DBMS_SYSTEM.GET_ENV() – tanelpoder.com
|
| 27. 3. 2009 | I’m an Oracle ACE Director now :) – tanelpoder.com
|
| 27. 3. 2009 | I’m an Oracle ACE Director now :) – tanelpoder.com
|
| 22. 3. 2009 | Oracle 11g: Reading alert log via SQL – tanelpoder.com
|
| 22. 3. 2009 | Oracle 11g: Reading alert log via SQL – tanelpoder.com
|
| 20. 3. 2009 | Another LatchProfX use case – tanelpoder.com
|
| 20. 3. 2009 | Another LatchProfX use case – tanelpoder.com
|
| 14. 3. 2009 | The real history of Oracle database revealed! – tanelpoder.com
|
| 14. 3. 2009 | The real history of Oracle database revealed! – tanelpoder.com
|
| 7. 3. 2009 | Oracle, Timesten and PL/SQL support – tanelpoder.com
|
| 7. 3. 2009 | Oracle, Timesten and PL/SQL support – tanelpoder.com
|
| 4. 3. 2009 | The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling – tanelpoder.com
|
| 4. 3. 2009 | The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling – tanelpoder.com
|
| 25. 2. 2009 | 60000 bind variables?! Maybe it’s time to use a temporary table instead… – tanelpoder.com
|
| 25. 2. 2009 | 60000 bind variables?! Maybe it’s time to use a temporary table instead… – tanelpoder.com
|
| 22. 2. 2009 | SQL_ID is just a fancy representation of hash value – tanelpoder.com
|
| 22. 2. 2009 | SQL_ID is just a fancy representation of hash value – tanelpoder.com
|
| 14. 2. 2009 | Performance Visualization, Capacity planning and Hotsos Symposium – tanelpoder.com
|
| 14. 2. 2009 | Performance Visualization, Capacity planning and Hotsos Symposium – tanelpoder.com
|
| 8. 2. 2009 | When was a table last changed? – tanelpoder.com
|
| 8. 2. 2009 | When was a table last changed? – tanelpoder.com
|
| 23. 1. 2009 | Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint – tanelpoder.com
|
| 23. 1. 2009 | Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint – tanelpoder.com
|
| 22. 1. 2009 | Identifying shared memory segment users using lsof – tanelpoder.com
|
| 22. 1. 2009 | Identifying shared memory segment users using lsof – tanelpoder.com
|
| 20. 1. 2009 | Reliable latch waits and a new blog – tanelpoder.com
|
| 20. 1. 2009 | Reliable latch waits and a new blog – tanelpoder.com
|
| 2. 1. 2009 | Oracle memory troubleshooting, Part 1: Heapdump Analyzer – tanelpoder.com
|
| 2. 1. 2009 | Oracle memory troubleshooting, Part 1: Heapdump Analyzer – tanelpoder.com
|
| 28. 12. 2008 | Performance Visualization made easy – PerfSheet 2.0 beta – tanelpoder.com
|
| 28. 12. 2008 | Performance Visualization made easy – PerfSheet 2.0 beta – tanelpoder.com
|
| 2. 11. 2008 | Little oradebug enhancement in Oracle 11g – tanelpoder.com
|
| 2. 11. 2008 | Little oradebug enhancement in Oracle 11g – tanelpoder.com
|
| 31. 10. 2008 | Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProf – tanelpoder.com
|
| 31. 10. 2008 | Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProf – tanelpoder.com
|
| 21. 10. 2008 | Transportable tablespaces and ROWID uniqueness – tanelpoder.com
|
| 21. 10. 2008 | Transportable tablespaces and ROWID uniqueness – tanelpoder.com
|
| 5. 9. 2008 | VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles – tanelpoder.com
|
| 5. 9. 2008 | VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles – tanelpoder.com
|
| 1. 9. 2008 | Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others – tanelpoder.com
|
| 1. 9. 2008 | Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others – tanelpoder.com
|
| 26. 8. 2008 | Flexible sampling of any V$ or X$ view with sample.sql – tanelpoder.com
|
| 26. 8. 2008 | Flexible sampling of any V$ or X$ view with sample.sql – tanelpoder.com
|
| 18. 8. 2008 | Case study on some rowcache internals, cached non-existent objects and a describe bug – tanelpoder.com
|
| 18. 8. 2008 | Case study on some rowcache internals, cached non-existent objects and a describe bug – tanelpoder.com
|
| 14. 8. 2008 | Why does even a small difference in SQL text cause a hard parse? – tanelpoder.com
|
| 14. 8. 2008 | Why does even a small difference in SQL text cause a hard parse? – tanelpoder.com
|
| 12. 8. 2008 | Script: Display valid values for multioption parameters (including hidden parameters) – tanelpoder.com
|
| 12. 8. 2008 | Script: Display valid values for multioption parameters (including hidden parameters) – tanelpoder.com
|
| 6. 8. 2008 | The simplest query for checking what’s happening in a database – tanelpoder.com
|
| 6. 8. 2008 | The simplest query for checking what’s happening in a database – tanelpoder.com
|
| 2. 8. 2008 | Library cache latches gone in Oracle 11g – tanelpoder.com
|
| 2. 8. 2008 | Library cache latches gone in Oracle 11g – tanelpoder.com
|
| 22. 7. 2008 | Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX – tanelpoder.com
|
| 22. 7. 2008 | Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX – tanelpoder.com
|
| 14. 7. 2008 | Closed database and WITH subquery – tanelpoder.com
|
| 14. 7. 2008 | Closed database and WITH subquery – tanelpoder.com
|
| 8. 7. 2008 | Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf – tanelpoder.com
|
| 8. 7. 2008 | Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf – tanelpoder.com
|
| 20. 6. 2008 | Another use case for WaitProf – diagnosing “events in waitclass Other” – tanelpoder.com
|
| 20. 6. 2008 | Another use case for WaitProf – diagnosing “events in waitclass Other” – tanelpoder.com
|
| 19. 6. 2008 | Killing an Oracle process from inside Oracle – tanelpoder.com
|
| 19. 6. 2008 | Killing an Oracle process from inside Oracle – tanelpoder.com
|
| 17. 6. 2008 | cursor_space_for_time To Be Deprecated – tanelpoder.com
|
| 17. 6. 2008 | cursor_space_for_time To Be Deprecated – tanelpoder.com
|
| 15. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain – tanelpoder.com
|
| 15. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain – tanelpoder.com
|
| 14. 6. 2008 | Debugger dangers – tanelpoder.com
|
| 14. 6. 2008 | Debugger dangers – tanelpoder.com
|
| 12. 6. 2008 | Short note on KGX Mutexes – tanelpoder.com
|
| 12. 6. 2008 | Short note on KGX Mutexes – tanelpoder.com
|
| 8. 6. 2008 | Generating lots of rows using connect by – safely! – tanelpoder.com
|
| 8. 6. 2008 | Generating lots of rows using connect by – safely! – tanelpoder.com
|
| 5. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL! – tanelpoder.com
|
| 5. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL! – tanelpoder.com
|
| 2. 6. 2008 | Performance Tools Quick Reference Guide – tanelpoder.com
|
| 2. 6. 2008 | Performance Tools Quick Reference Guide – tanelpoder.com
|
| 2. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue – tanelpoder.com
|
| 2. 6. 2008 | Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue – tanelpoder.com
|
| 2. 6. 2008 | Snapper shortcut – tanelpoder.com
|
| 2. 6. 2008 | Snapper shortcut – tanelpoder.com
|
| 30. 5. 2008 | Querying the current tracefile name, using SQL – with tracefile_identifier – tanelpoder.com
|
| 30. 5. 2008 | Querying the current tracefile name, using SQL – with tracefile_identifier – tanelpoder.com
|
| 30. 5. 2008 | Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation – tanelpoder.com
|
| 30. 5. 2008 | Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation – tanelpoder.com
|
| 25. 5. 2008 | Performance and Scalalability Improvements in Oracle 10g and 11g – tanelpoder.com
|
| 25. 5. 2008 | Performance and Scalalability Improvements in Oracle 10g and 11g – tanelpoder.com
|
| 25. 5. 2008 | Using autonomous transactions for sleeping – tanelpoder.com
|
| 25. 5. 2008 | Using autonomous transactions for sleeping – tanelpoder.com
|
| 9. 4. 2008 | SQL*Net break/reset to client – tanelpoder.com
|
| 9. 4. 2008 | SQL*Net break/reset to client – tanelpoder.com
|
| 10. 2. 2008 | SQL*Net message to client vs SQL*Net more data to client – tanelpoder.com
|
| 10. 2. 2008 | SQL*Net message to client vs SQL*Net more data to client – tanelpoder.com
|
| 7. 2. 2008 | SQL*Net message to client wait isn’t really what it’s thought to be – tanelpoder.com
|
| 7. 2. 2008 | SQL*Net message to client wait isn’t really what it’s thought to be – tanelpoder.com
|
| 4. 2. 2008 | Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally? – tanelpoder.com
|
| 4. 2. 2008 | Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally? – tanelpoder.com
|
| 3. 2. 2008 | Excellent article on Oracle 11g PL/SQL function result cache – tanelpoder.com
|
| 3. 2. 2008 | Excellent article on Oracle 11g PL/SQL function result cache – tanelpoder.com
|
| 14. 1. 2008 | Can you write a working SQL statement without using any whitespace? – tanelpoder.com
|
| 14. 1. 2008 | Can you write a working SQL statement without using any whitespace? – tanelpoder.com
|
| 9. 1. 2008 | Expensive calculator… – tanelpoder.com
|
| 9. 1. 2008 | Expensive calculator… – tanelpoder.com
|
| 7. 1. 2008 | Why does Oracle parameter count change during session lifetime? – tanelpoder.com
|
| 7. 1. 2008 | Why does Oracle parameter count change during session lifetime? – tanelpoder.com
|
| 5. 1. 2008 | Systematic application troubleshooting in Unix – tanelpoder.com
|
| 5. 1. 2008 | Systematic application troubleshooting in Unix – tanelpoder.com
|
| 28. 12. 2007 | Perl version of Snapper – tanelpoder.com
|
| 28. 12. 2007 | Perl version of Snapper – tanelpoder.com
|
| 25. 12. 2007 | Sqlplus is my second home, part 5: Reading the name of currently executing script – tanelpoder.com
|
| 25. 12. 2007 | Sqlplus is my second home, part 5: Reading the name of currently executing script – tanelpoder.com
|
| 18. 11. 2007 | Oracle Security, Part 2: Your read only accounts aren’t that read only – tanelpoder.com
|
| 18. 11. 2007 | Oracle Security, Part 2: Your read only accounts aren’t that read only – tanelpoder.com
|
| 6. 11. 2007 | Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable – tanelpoder.com
|
| 6. 11. 2007 | Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable – tanelpoder.com
|
| 19. 10. 2007 | A simple interview question – tanelpoder.com
|
| 19. 10. 2007 | A simple interview question – tanelpoder.com
|
| 16. 9. 2007 | How to resolve SQL object and column names all the way to base tables and columns in Oracle? – tanelpoder.com
|
| 16. 9. 2007 | How to resolve SQL object and column names all the way to base tables and columns in Oracle? – tanelpoder.com
|
| 5. 9. 2007 | Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stack – tanelpoder.com
|
| 5. 9. 2007 | Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stack – tanelpoder.com
|
| 1. 9. 2007 | Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt – tanelpoder.com
|
| 1. 9. 2007 | Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt – tanelpoder.com
|
| 30. 8. 2007 | Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP – tanelpoder.com
|
| 30. 8. 2007 | Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP – tanelpoder.com
|
| 28. 8. 2007 | Operating systems are lazy allocating memory – tanelpoder.com
|
| 28. 8. 2007 | Operating systems are lazy allocating memory – tanelpoder.com
|
| 26. 8. 2007 | Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do – tanelpoder.com
|
| 26. 8. 2007 | Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do – tanelpoder.com
|
| 26. 8. 2007 | Oracle Session Snapper, part 2: Getting most out of Snapper – tanelpoder.com
|
| 26. 8. 2007 | Oracle Session Snapper, part 2: Getting most out of Snapper – tanelpoder.com
|
| 20. 8. 2007 | Oracle 11g internals part 1: Automatic Memory Management – tanelpoder.com
|
| 20. 8. 2007 | Oracle 11g internals part 1: Automatic Memory Management – tanelpoder.com
|
| 19. 8. 2007 | Oracle Session Snapper – real-time session-level performance stats for DBAs – tanelpoder.com
|
| 19. 8. 2007 | Oracle Session Snapper – real-time session-level performance stats for DBAs – tanelpoder.com
|
| 7. 8. 2007 | Sqlplus is my second home, Part 1: HTMLizing your sqlplus output – tanelpoder.com
|
| 7. 8. 2007 | Sqlplus is my second home, Part 1: HTMLizing your sqlplus output – tanelpoder.com
|
| 24. 6. 2007 | Session-level statspack – tanelpoder.com
|
| 24. 6. 2007 | Session-level statspack – tanelpoder.com
|
| 23. 6. 2007 | A gotcha with parallel index builds, parallel degree and query plans – tanelpoder.com
|
| 23. 6. 2007 | A gotcha with parallel index builds, parallel degree and query plans – tanelpoder.com
|
| 19. 6. 2007 | My version of SQL string to table tokenizer – tanelpoder.com
|
| 19. 6. 2007 | My version of SQL string to table tokenizer – tanelpoder.com
|
| 18. 6. 2007 | Advanced Oracle Troubleshooting Guide: When the wait interface is not enough [part 1] – tanelpoder.com
|
| 18. 6. 2007 | Advanced Oracle Troubleshooting Guide: When the wait interface is not enough [part 1] – tanelpoder.com |