Tag Archives: Tools

Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX

In my last AOT post I published my LatchProf script which is able to sample detailed latchholder data from V$LATCHHOLDER. Latchprof allows you to drill down into your latching problems at session level (which V$LATCH, V$LATCH_PARENT and V$LATCH_CHILDREN can’t do). … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , | 15 Comments

Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain

Get ready for some more adventures in Oracle process stack! Before proceeding though, please read this post about safety of different stack sampling approaches. I have had few non-trivial Oracle troubleshooting cases, related to query hangs and bad performance, where … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , , , | 28 Comments

Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!

I bet you thought I’ll be writing about direct SGA access?! ;) Nope! Direct SGA access has excellent troubleshooting potential (as long as you know the shared memory data structures), but it has one major drawback – very few companies … Continue reading

Posted in Cool stuff, Oracle | Tagged , , , , | 31 Comments