Lalit Chhimwal

• Aug 6th, 2006

 

buffer busy wait is the condition in which oracle server has to wait to access the segment header block for the table on which concurrent insert or delete operation r to be done.the segment header block contains control info including header link for free list blocks for table,if we increase the freelist or freelist_group paramater,it gives multiple segment headers.which reduces the "buffer busy wait"