Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Coalescing Empty SPace in a Data Block

Coalescing Empty SPace in a Data Block

From: Barry Sieben <BJSIEBEN_at_bcsc02.gov.bc.ca>
Date: 1997/09/05
Message-ID: <17BE0EDF8S86.BJSIEBEN@bcsc02.gov.bc.ca>#1/1

 

Does anyone know how/if you can force Oracle to colesce the empty space within a data block? We are able to coalesce empty blocks within a segment, but how does Oracle (specifically smon) know if/when to coalesce empty contiguous space within a data block?              

Regards,

Barry Sieben, OSG, ITSD          | Voice: (250) 387-9394
3Gr/E317, 4000 Seymour Place     | Fax:   (250) 387-5766
Victoria, BC, V8X 4S8            | IN: bjsieben_at_bcsc02.gov.bc.ca
Received on Fri Sep 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US