Tag Archives: Tools

Sometimes things are easy (Part 1): How to fix wrapped execution plan text?

What you see below is a common problem. Someone sends you (or posts to a forum) a wide execution plan, which is unreadable because of wrapped lines. For example, this one below: ——————————————————————————– ——————- | Id  | Operation                   | Name                    … Continue reading

Posted in Oracle, Productivity | Tagged , , | 1 Comment

latch: cache buffers chains latch contention – a better way for finding the hot block

Here’s a treat for Oracle performance professionals and geeks who are looking for more systematic ways for cache buffers chains (CBC) latch contention troubleshooting. Cache buffers chains latches are taken when a process wants to walk through a cache buffer … Continue reading

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

Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others

I have written two posts in one, about a performance issue with writes in system tablespace and introduction of a little DTrace stack sampling script. Have you noticed that DML on tables residing in SYSTEM tablespace is slower than tables … Continue reading

Posted in Oracle | Tagged , , , , | 30 Comments