Latch Performance Question
Hello all, is there any way to see how long a particular session maintained a hold on a latch? My specific desire is to see how long a session held onto the cache buffers chains latch while traversing through the chain. I understand that this time would be only microseconds, but I'm trying to chase down a performance issue.
Another thing I could look at is the length of the cache buffers chains (I hope I'm saying that right). If there is a way to look at the length (or average length) of chains I'd also appreciate any insight for this as well.
This is 10.2.0.3 enterprise edition running on Oracle Linux 5.5
Thanks,
Michael Cunningham