ANTONYRAJ CHINNAPPAN, April 27, 2010 - 1:10 pm UTC
Thanks Tom!
Antony, April 27, 2010 - 1:12 pm UTC
I guess you didn't answer the question on solitary latches.
April 27, 2010 - 1:29 pm UTC
Tell me what a solitary latch is - do you mean a parent latch without any children - they are solitary. It is just a latch.
Latch Children
A reader, February 01, 2013 - 4:37 am UTC
Tom,
I had queried v$latch_children for the latch "Cache Buffer lru chains" . I could see that , of the available 256 children, only 2 children had gets,misses,sleeps a high count. Rest of the children had '0' value for all columns except gets. Does this mean only 2 children are used? Does the no of children used depends on the load.
February 01, 2013 - 8:48 am UTC
if you see some gets, you are seeing others being used...