cache buffer chains latch

[Sultan Syed]

Hi All,   My system is suffering in cache buffer chain,I found the reason. My general questions is 1) When the process holding the latch how long the latch will be held ,until the hase chain is read or the process goes to the particular block and return the rows(output) ?   2) When the situation will occur for the process to hold two latches(different or same) simultaneously ?   Please reply.   Syed.