Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Statistics doesn't match reponse time?
Hi jonathan
Below is a quote from you
"Buffer busy waits (of the change/change type) appear when one session pins exclusive and another wants to pin exclusive - the second session attaches to the 'waiters' pin-list and waits for the buffer to become available. But buffers are usually only pinned exclusive for very short periods. "
Lets say a session pins a buffer in exclusive mode to make some changes.
At the same time a session wants to read data from the buffer.
Won't the second session (reader) would have to wait on buffer busy wait (120) till the first session has finished its change, so that it sees a consisten buffer ?
thanks
amit
for very short periods.
Received on Mon Sep 12 2005 - 16:41:59 CDT
![]() |
![]() |