Another cache buffers chains latch contention troubleshooting example using LatchProf

One of my blog readers recently dropped me an email noting that he had noticed some cache buffers chains latch contention recently and successfully troubleshooted it with LatchProf. I asked if he’d like to blog about it and here’s the article:

Cache buffer chains latch contention typically shows up when some execution plans go bad, switching to nested loops or filter loops and revisiting the same table (or index) blocks very frequently…

Note that this year’s only Advanced Oracle Troubleshooting class takes place in the end of April/May 2014, so sign up now if you plan to attend this year!

This entry was posted in Oracle and tagged , . Bookmark the permalink.

2 Responses to Another cache buffers chains latch contention troubleshooting example using LatchProf

  1. Andriy Dmytrenko says:

    The article you gave in the post is no longer available, WP says “orapsdba.wordpress.com is no longer available”.
    But it is still reachable from web archive: http://web.archive.org/web/20111113062613/http://orapsdba.wordpress.com/2011/06/21/another-latchcache-buffer-chains-troubleshooting

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>