Converting Offsets in Disassembled Code to Hexadecimal Notation
Perl one-liner for converting offsets in gdb output to hex Continue Reading
gdb
Three Ways to Suspend an Oracle Process
While analyzing complex problems and researching internals in Oracle database, I’ve often had to observe process interaction in slow motion. This requires temporarily suspending a process until another process finishes a relevant chunk of work, and then resume the suspended… Continue Reading
parallel recovery push change
A stuck nanosleep call impairs a parallel recovery process. The affected parallel recovery process spends 100% of its time in the undocumented parallel recovery push change wait event. Continue Reading
Transaction start_time Internals
Troubleshooting wrong v$transaction.start_time entries. Undocumented internals on how Oracle populates x$ktcxb. Continue Reading
Deadlock Caused by Row Cache and Library Cache Locks
Reproducing Oracle deadlock bug with debugger Continue Reading
Enriching Trace with Call Stacks Part 2: gdb
How to use gdb for capturing call stacks when trace lines are written Continue Reading
Bad commit Performance due to Slow Control File Writes
Analyzing slow commits with ash_wait_chains.sql, gdb and DTrace Continue Reading
Tracking Arguments with gdb
Tracking function arguments with gdb, with an example of tracing memory allocations in Oracle database Continue Reading
IO Sort Cost Calculation
IO Sort Cost Calculation: formulae and internals Continue Reading
Tracking the Optimizer with gdb
Tracing a low-level Oracle C function for getting insights into the optimizer decision making Continue Reading