Cool Stuff

• Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication
• Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too
• My New Youtube Channel
• Old ventures and new adventures
• ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support
• Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script!
• Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)
• Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output
• Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking
• Evil things are happening in Oracle
• V8 Bundled Exec call – and Oracle Program Interface (OPI) calls
• Tech Reviewer, Tech Reviewer! ;-)
• IOUG Select Journal Editor’s Choice Award 2011
• Latch contention troubleshooting case study and Flashback Database performance issues with LOBs
• MOATS: The Mother of All Tuning Scripts!
• Implicit datatype conversion in the parsing phase – something new I learned today!
• ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!
• Is this valid SQL syntax? :-)
• COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results
• The most fundamental difference between hash and nested loop joins
• Oracle Closed World presentation links
• The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements
• Flexible Sqlplus command line history with RLWRAP
• Execution plan Quiz: Shouldn’t these row sources be the other way around ;-)
• Quiz: Explaining index creation
• KGH: NO ACCESS – Buffer cache inside streams pool too!
• Calculate SQL_ID and SQL_HASH_VALUE from SQL text
• Oracle Latch Contention Troubleshooting
• New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning
• Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!
• Oracle Wait Event reference
• Oracle Peformance Visualization…
• Finding the reasons for excessive logical IOs
• What’s a good way to learn some Oracle internals every day?
• SystemTap is production supported in Redhat EL5.4
• latch: cache buffers chains latch contention – a better way for finding the hot block
• An interview with me
• (Secret) Preview of Oracle 12g CBO leaked from Oracle labs…
• Using Perfsheet and TPT scripts for solving real life performance problems
• I have been troubleshooting since I was a kid! :)
• Tracing Oracle SQL plan execution with DTrace
• Read OS environment variables using DBMS_SYSTEM.GET_ENV()
• I’m an Oracle ACE Director now :)
• The real history of Oracle database revealed!
• The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling
• SQL_ID is just a fancy representation of hash value
• Performance Visualization, Capacity planning and Hotsos Symposium
• Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint
• Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
• Closed database and WITH subquery
• Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf
• Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain
• Generating lots of rows using connect by – safely!
• Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!
• Using autonomous transactions for sleeping
• Can you write a working SQL statement without using any whitespace?
• Expensive calculator…
• Perl version of Snapper
• Sqlplus is my second home, part 5: Reading the name of currently executing script
• Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable
• Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt
• Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP
• Oracle Session Snapper, part 2: Getting most out of Snapper
• Oracle Session Snapper – real-time session-level performance stats for DBAs
• Sqlplus is my second home, Part 1: HTMLizing your sqlplus output