v$session_wait, I see that a couple of latches are hot. I will consider one latch children with latch address
19875043200 as an example, and drill down further.
Hang Those Buffers!
Next, I needed to find buffers protected by these latch children, and then find the buffers causing latch contention. Many such hash buckets (and so, numerous buffers) are protected by a latch children.
I don’t favour the above script, since its performance is not optimal. It is much easier to dump the blocks and convert them to object ids. Let’s dump these three blocks.
Now I can query
dba_objects to find the