My current understanding is:
a)For normal buffer gets,
the latch is acquired,
the chain is scanned
the buffer is pinned
the latch is released
the buffer is used
--
the latch is acquired
the pin is
Going by the original poster's use of the word suffering, there were at
least 2 unprintable bugs in 8i prior to 8.1.7.4, if the versions are
relevant in this case.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 9:39 PM
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
longthe latchwill be held ,until the hase chain is read or
the process goes to
the particular block and return the rows(output) ?
2)
When the