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> wrote:
> If Buffer busy wait indicates that "multiple process are trying to
> access a buffered block simultaneously". How can segment header
> (freelist contention) can be a reason for this. ? Segment Header is
> there in the physical files. How can this cause BUFFER busy wait.
You can't do anything with a segment header while it is merely in the physical file. If you are going to do something with it, it needs to be buffered, just like other blocks do.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Wed Mar 22 2006 - 15:02:00 CST