Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer busy wait clarification
"Chintu" <agarwalp_at_eeism.com> ha scritto nel messaggio
news:1143088033.953449.317430_at_j33g2000cwa.googlegroups.com...
.> [...]
> This is what I am not able to understand. How can segment header
> (freelist contention) be a reason for buffer busy waits ???
It may be a reason when multiple processes are attempting to access concurrently the same segment header block/s to get or modify the process FREELISTS information in the buffer cache - this is serial, one at a time, operation (when inserting and searching for free blocks or deleating and adding free blocks to the freelist, for example).
If it's still not clear, you could try to formulate the question in a different manner.
Regards,
Dimitre
Received on Thu Mar 23 2006 - 02:21:19 CST